Up & Running with PowerBI
- Date : 17 - 18 February 2023
- Duration : Day(09:30 AM-05:30 PM)
- No. of Classes/ Sessions : 2 Days
- Class Schedule : Friday & Saturday
- Total Hours : 16
- Last Date of Registration : 15 February, 2023 ( within 5pm )
- Venue : Bdjobs Training, BDBL Building (Level 08), 12 Kawran Bazar C/A, Dhaka 1215.
- There will be prayer break in between
Introduction
Power BI is the newest Microsoft Business Intelligence and Data Analysis tool. It bring your business data to life. It is a suite of business analytics tools that deliver insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis.
Benefits you using PowerBI:
• A full suite of BI tools for data visualization and reporting - access and unify data across sources
• Transform company data into rich visuals - create live, real-time data metric dashboards.
• Easily share reports among colleagues and users via the Power BI Online Service
Course Overview:
This course begins with Power BI basics. You will navigate the software, connect it to a data file, and start playing, so even beginners will feel completely at ease.
To be able to find trends in your data and make accurate forecasts, you'll learn how to work with hierarchies and timeseries. Also, to make data easier to digest, you'll tackle how to use aggregations to summarize information. You will also use granularity to ensure accurate calculations.
In order to begin visualizing data, you'll cover how to create various charts, maps, scatterplots, and interactive dashboards for each of your projects. You'll even learn how to join multiple data sources into one in order to combine diverse sources of information in one analytical solution.
Finally, you'll cover some of the latest and most advanced custom visualizations in Microsoft Power BI, where you will create histograms, brickcharts and more.By the time you complete this course, you'll be a highly proficient Power BI user. You will be using your skills as a data scientist to extract knowledge from data so you can analyze and visualize complex questions with ease. You'll be fully prepared to collect, examine, and present data for any purpose, whether you're working with scientific data or you want to make forecasts about buying trends to increase profits.
Methodology
This will be an instructor led program delivered through hands on labs with real life example. Audience will taste a new level of experience by attending the course.Contents of Training:
Connect your dataExplore your data wherever it is - produce beautiful reports, then publish them for your organization to consume on the web and across mobile devices.
1. Data Visualization
• Understand the concept of BI
• Introduction to Power BI and Its History
• Formatting Visuals in Power BI Desktop
• Basic Charts and Visuals in Power BI
• Custom Visuals in Power BI Desktop
• Maps and Geo-Spatial Visualization
• Timeline and Utilizing PowerBI AI
• Trend Line and Forecasting
• Conditional Formatting
• Analyzing through Decomposition Tree
• Learn to use Bookmark
• Learn to Controlling the interaction of Visuals
• Group and Binning
2. Data Modelling and DAX
• Understand and Create Data Models
• Hierarchies and Formatting
• Sorting by other columns
• Introduction to DAX
• Calculated Columns, Measures, and Calculated Tables
• Learn Dax Time Intelligence Functions
• Learn how RELATED function can replace VLOOKUP
• Learn how the IF functions is stronger than that of excel
• Learn to use CALCULATE functions to replace SUMIFS
3. Extract Data, Transformation and Load [ETL]
• Power Query Introduction and understand its Role
• Learn to import data from excel sheet or table
• Learn to load data from a folder automatically
• Learn to import data from SQL Server
• Learn to Transform Ugly Data through Query Editor
• Learn to Understand Concept and usage of Data Quality
• Get Started with Data Mash-Up through Append and Merger
4. Power BI Service
• Basic Sharing and using workspaces in Power BI web site
• Dashboard vs. Report
• Power Q&A
• Collaborate report and dashboard with colleagues
• Mobile Dashboard Design
• PowerBI App [Not the Mobile]
• Setting Permission in workspace
• Schedule Refresh vs. Other types of connections
• Gateway’s Role in the Service
• Learn how to Embed Data in Website
• Analyze with Excel
• Export to PDF and PowerPoint
Related Courses
Resource Person
Samiul Huq
Founder and Chairman
He is the team lead of the Routing Team [A combine team from Marketing, Billing and Core Network] at NovoTel Limited. He is also Supervising the technical team of Revenue Assurance Department- taking care of technical related issues in the whole RA Value Chain including designing, preparing and implementing the Least Cost Routing using spreadsheet technology. It also includes preparing scripts for switches and doing the routing decision, all using MS Excel. He is also leading a BI program- deploying the Business Intelligence Stack of Microsoft Technology that includes Sql Server 2008 [Analytical Service, Integrating Service and Reporting Service] and then publishing it over SharePoint 2010. Mr Huq is a part time excel trainer. He has had expertise in Database [Oracle Certified], Visual Basic for Application, Telecom Architecture and Business, Billing and Routing Software, Networking and Virtualizations.
Bdjobs
Android App
Facebook
Google
LinkedIn
Instagram
