New solution added! ‘Sort Visuals On Text Dimensions’ – 04-17-2020
In this solution we explain how you can sort your visuals when using text dimensions on your axis. The default way of sorting a text dimension is from a to z. But when for example visualizing your data per month you don’t want your months starting in April and ending in September. In this solution we show you all the tips and tricks to deal with this problem.
Training 14-5 : Level 1 Fundamentals
Do you also struggle with your reports in Excel every month? Would you like to explore your data but don’t know how? Do you want to create beautiful dashboards and easily share them with your colleagues or external parties? In other words; are you ready for a whole new way of analyzing and presenting data?
Welcome! Power BI is going to help you do everything much easier and faster and offers you a world of new possibilities. In this Level 1 training we will show you in one day how the program works and we will teach you based on Excel data how to efficiently and effectively create a dashboard.
• General introduction in Power BI
• DISP method
• Import data in Power BI
• Format and structure data
• Establish and manage relationships
• Create reports with the most used visuals
• Drawing up and analyzing visuals
• Upload your report to Power BI Online
• Create dashboards in Power BI Online
• Sharing your reports and dashboards
Training 28-5 : Advanced Reporting
Have you been making reports in Power BI for a while? Are you curious how you can take your reports to a much higher level? Do you want to be completely up-to-date (again) with regard to the latest features in Power BI?
Welcome! The Advanced Reporting training offers you a world of new possibilities. In this training we will show you in one day what options there are to set up your reports using User Centered Design. We will teach you everything related to storytelling, implementing corporate identity, advanced analyzing etc. After this training you can build reports that will leave everyone amazed!
Subjects
- 10 golden rules for creating reports
- Tooltips
- Drilltrough
- Corporate identity
- Bookmarks o.a. navigation, slicer panel etc.
- Dynamic titles
- Grouping your data in your visuals
New solution added! ‘Datable Fiscal Year DAX’ – 04-15-2020
In this solution we explain how to deal with a fiscal year in Power BI. We show you how to create a datetable which contains the right fiscal year, quarter, month, weeknumber etc. You can use this datetable to analyse, filter and visualize your data based on the right dimensions for your fiscal year.
New solution added! ‘Pareto Analysis DAX’ – 04-13-2020
In this solution we explain how te set up a pareto analysis in Power BI. The pareto in this example shows you the percentage of sales which is generated by an x percentage of customers. Besides that we created a drilltrough to show which customers are generating that x percentage of sales.
Training 12-6 : Level 2 Fundamentals
You are now reading the information about the Level 2 training. This means that you already work with Power BI or that you have followed Power BI Level 1 Fundamentals. So we don’t have to get you excited about Power BI anymore, we’re sure you’ve already become one!
In this Level 2 training we will really boost your knowledge in one day. Because there is much more to learn about Power BI. How about importing data from all kinds of different sources, such as SQL, websites and folders? We will also teach you how to add calculations and measurements to your data using DAX and you will work with geographic visualizations. After this training you will have all the tools in hand to deal with all the most common things in Power BI.
- Import data from SQL, Folders and Web
- Complex relationships:
- 1 to 1
- Many tot many
- Cross filter directions
- Introduction to DAX
- What about the syntax
- Measures versus calculated columns
- Basic measurements
- Date expressions including creating a datetable
- Filter your calculations using Calculate
- Geographic visuals
- Creating workspaces in Power BI Online and implementing self service BI