General Power BI information for mini guide.
I'm writing a mini guide on data analytics for ICAEW, which is the largest body of chartered accountants in the UK. I've included a list of questions below and would greatly appreciate if you could Note that these don't have to be quotes it is more for general background information to help[ me write the BI section. Additionally, is there an on demand video of key features available? If so this would be handy too. 1. Please list BI’s key features 2. Which accountancy software platforms integrate directly with BI, and can you please link me a full directory of direct add ons. 3. Which sectors and size of business is BI most suitable for? 4. Are you able to please provide me with a couple of examples of how finance leaders/teams can use BI within their roles and for use across their wider companies? 5. What makes BI unique amongst its competitors? Would truly appreciate any answers for this.
Public Dashboard Creation
I have been tasked with creating a public facing dashboard. This dashboard cannot interact directly with our database so I would build an excel spreadsheet that would populate the dashboard. We want to refresh it every 2 weeks with the most current data. We would like for there to be sliders so that people can narrow by time, location, and other types of general parameters. Our license is through the university we are housed in though I am not sure exactly what is needed for this dashboard. Where can I find trainings to help me do this? Thank you, Gari
Inflation Rates Adjusting Year of Payout to Loss Year accounting for inflation
Hello, I have been tasked out with creating a dashboard that shows the payout spend compared to the loss year spend, accounting for inflation (year over year, various years). Basically, I want to see if im spending more money today than the loss date. Data and rates below. Payout Date Loss Date (Year) Payout Year Region Total Inflation Rate Year 1-Jan-24 2023 2024 A -1547.72 2.10% 2017 1-Jan-24 2023 2024 B 4040.44 2.40% 2018 1-Jan-24 2023 2024 C 104.2 1.80% 2019 1-Jan-24 2023 2024 A 12231 1.20% 2020 1-Jan-24 2019 2024 B 2561.4 4.70% 2021 1-Jan-24 2023 2024 A 27135.18 8.00% 2022 1-Jan-24 2022 2024 B -12285.27 4.10% 2023 1-Jan-24 2023 2024 A 315123 0.00% 2024 1-Jan-24 2014 2024 B 407 1-Jan-24 2017 2024 A 200206.6 1-Feb-24 2023 2024 B 749.47 1-Feb-24 2023 2024 C 22837.77 1-Feb-24 2017 2024 A 7 1-Feb-24 2023 2024 B 15403.35 1-Feb-24 2024 2024 C 165 1-Feb-24 2023 2024 A 406.98 1-Feb-24 2022 2024 B 31.35 1-Feb-24 2016 2024 C 1986 1-Feb-24 2023 2024 A 7497.12 1-Feb-24 2023 2024 B 12342.62 1-Feb-24 2015 2024 C 4964.75 1-Apr-23 2014 2023 A 3161.5 1-Apr-23 2017 2023 B 6064.65 1-Apr-23 2019 2023 C 492.27 1-Apr-23 2017 2023 C 2628 1-Apr-23 2023 2023 C 72 1-Apr-23 2023 2023 A 4952.46 1-Apr-23 2015 2023 B 200.48 1-May-23 2023 2023 C 68621.64
How to calculate rows on a table?
How to calculate rows on a table? I want to create a column "started" as below, for each row of this column I need the result of this excel like formula: =IF(AND(A3=A2;B3-B2<1);"No";"yes") part install date started PAU-0101 26/03/2019 05:17 yes PAU-0101 07/04/2019 18:56 No PAU-0101 07/04/2019 19:56 yes PAU-0102 26/03/2019 05:17 yes PAU-0102 07/04/2019 18:56 No PAU-0102 07/04/2019 19:56 yesCalculating worked days
Hi all I am a beginer with Power BI so please be so kind and help me. I have 3 tables : - Dates - Technician - Leaves What I need , is first to calculate how manny working days are in Dates table , and then to calculate the effectivley worked days for each technician which had an leave . Thank you in advance for your help!Global Power Platform Bootcamp 2020, Hamburg Edition on 15.02.2020
On this day, we will join the Global PowerPlattform Bootcamp. Find more information on https://www.meetup.com/de-DE/Office-365-User-Group-Hamburg/events/267203284/ This year we will provide 2 tracks with workshops (120 mins) and sessions (60 mins), including a colorful mix of almost each topic covered by Power Platform. While some of the speakers also support German sessions, we currently plan and describe all the sessions in English, so we hope our international members will also get a great experience during this bootcamp.
Global Power Platform Bootcamp 2020 - Zaragoza, Spain - 15 Feb 2020
Hola a todos! Microsoft ha impulsado un evento global, con 44 localizaciones en todo el mundo, respaldado por distintios grupos de usuarios y comunidades y nosotros en Zaragoza hemos pensado que es un buen momento para volver a poner a nuestra maravillosa ciudad en primera linea, lanzando este evento, que con vuestra ayuda será el primero de muchos. El propósito de este evento es acercar Power Platform a cualquier pesona que quiera empezar a usarla y ayudarle a responder a las siguientes preguntas: ¿Qué es? ¿Para qué sirve? ¿Cómo empiezo? En el evento hablaremos de ¡Un poderoso conjunto de herramientas para facilitarle la vida! Power Apps. Power Automate / Flows. Power BI. Lo más importante para nosotros es empezar a hacer comunidad y que podamos ir generando eventos, reuniones y talleres con asiduidadad para poner tener un tejido de comunidad cada vez más fuerte 🙂 Para obtener la entrada puedes acceder a la siguiente dirección: https://www.eventbrite.com/e/global-power-platform-bootcamp-zaragoza-tickets-94267688193 Nos vemos el sábado 15 de febrero de 2020 a las 10:00 AM. ¡Os esperamos!
