Power BI Bootcamp: Build Real World Power BI Projects
What you'll learn
- Understand the business intelligence workflow from end-to-end
- Connect Microsoft Power BI to data sources
- Learn to create powerful reports and dashboards with Microsoft Power BI with a few clicks of the mouse
- Design and implement the same B.I. tools used by professional analysts and data scientists
Requirements
- basic knowledge of Power B.I
Description
Gartner has ranked Microsoft a Leader in the Gartner 2020 Magic Quadrant for Analytics and Business Intelligence Platforms for the thirteenth year in a row.
Power BI makes it incredibly simple to consolidate your data into a single location for improved accessibility, organisation, and visibility in your reporting efforts. It supports up to 70+ connectors, allowing businesses to load data from a wide range of popular cloud-based sources, including Azure (Azure Data Warehouse), DropBox, Google Analytics, OneDrive, and SalesForce, as well as Excel spreadsheets, CSV files, and data stored on-premises, such as SQL Database.
You can load pre-built Power BI dashboards in seconds and execute advanced data analysis in minutes with these built-in connections. You can always further customise aspects to your preference, or have your data professionals start by importing your datasets and creating your own dashboards and reports.
Power BI’s drag-and-drop interface also eliminates the need to code or copy and paste anything to get started, and Power BI can combine various files (like Excel spreadsheets) and analyse the combined data in a single report.
Power BI’s Power Pivot data modelling engine (shared with Excel) is a highly performant columnar database that compresses databases and ensures they load fully into memory for the greatest possible speed.
It’s fairly uncommon for your Power BI Workbook (.PBIX file) to be much less than your original data sets – in fact, 1GB databases are typically compressed down to roughly 50 – 200MB in size.
While Excel begins to slow down when dealing with huge models, Power BI is designed to handle tables with more than 100 million records without breaking a sweat. Power BI also uses automatic, incremental refreshes to ensure data is constantly up to date, which is a great benefit that further simplifies visual reporting for end users.
In summary, Power BI effectively condenses and loads millions of records into memory, allowing end-users to have a faster and more responsive data analysis experience.
Power BI has a multitude of pre-packaged basic data graphics to use in your interactive reports, including bar, column, line, map, matrix, pie charts, scatter, table, and waterfall – each with its own set of customisation options for improved presentation and usefulness.
However, to add a personal touch, you may utilise free custom graphics produced by developers (or in-house) and shared with the Power BI community to display your data in the best way possible.
There’s a remarkable selection of rich and complicated graphics to take use of, including bullet graphs, correlation plots, decision trees, heatmaps, sparklines, and more, with custom visual files accessible from both Microsoft and the community over at the AppSource Marketplace.
If you want to show your data in a unique way, Power BI allows you to easily design your own visualisations rather than being limited to the standard options. It’s also really beneficial to observe and apply what the larger Power BI community is doing to improve your own design skills.
Who this course is for:
- Beginners in Power B.I
Instructor
I have been working as an ML Engineer for roughly 4 years now and worked in other Data Science Jobs along the way. If you are like me once planning to transition from either your university life into the ML Engineering world or going from a different job into this exciting field. I am going to walk you through the steps that I would take if I was starting over today, on what exactly I would be focusing on, and then give you a rough time estimate on how long you should focus on each area, such that you can step by step improve your skills throughout the year. We will finish off with a lot of concrete tips on how to turn these skills into a job offer and where to actually learn them.