- Course-End Certificate
Power BI: Turn Your Data into Opportunities
The course is designed for the people who have basic knowledge in computing. Any professional who involves in business decision making process or helps decision makers by providing real time & actionable insights can join this course. This course is suitable for them who wants to build their career in Management Information System, Financial Analysis, Business Analytics & Strategic Business Planning related functions. Looking into the busy schedule of working people, we have schedule the class in the evening.
Duration
12 Hours
Mode
Live Online (Zoom)
Certification
Course Certificate
Course Free
BDT 3,000
Why Power BI is Crucial for Your Career
Business Intelligence with Microsoft Power BI course imparts skills and knowledge to Analyze, Visualize and Report data. Power BI is a suite of tools for Business Analytics that allows corporate users to analyze data and get insights that can help in making right business decisions. This Power BI training covers the latest tools to monitor business growth and quickly get answers on any device through rich reporting features and dashboards. Learn how to connect and import your data, author reports, publish reports, create dashboards, and share with business users so that they utilize the business intelligence gathered in dashboards through the web as well as mobile devices.
Data is valuable if you can analyze & visualize it very well for business decision. Power BI is appropriate tool to analyze and visual the data and help to take right business decision.
Database Design & Management
Learn to create, organize, and manage databases, tables, indexes, and relationships efficiently.
Advanced SQL Programming
Develop practical skills in queries, joins, views, stored procedures, and triggers.
Security & Performance Optimization
Learn database security, access control, backup, recovery, and query performance improvement.
Career & Professional Development
Build practical skills for database development, database administration, and data management roles.
Course Schedule
Orientation
25th October 2024 at 7PM
Class Starts
27th October 2024
Schedule
Friday & Saturday 7PM to 9PM
Comprehensive Course Coverage
- Day 1
- What is Power BI
- Why Power BI
- How Power BI Works
- How to Install Power BI
- Day 2
- Connecting to a database
- Merge
- Split and Trim
- Upper, Lower and Proper
- Add Suffix and Prefix
- Left, Right and Mid
- Extract Text with Delimiter
- Day 3
- Year, Quarter, Month, Day
- Difference between Dates, Earliest and Latest
- Name of Day and Name of Month
- Day of Week/Month/Year & Week of Month/Year
- Extract Date from Date and Time
- Calculate Age in 2 button Clicks
- Which day of Year, Quarter, Month your Date of Birth is
- Day 4
- Add, Subtract, Divide, Multiply
- Percentage, Percent of, Modulo
- Rounding the numbers
- IsEven, IsOdd and Sign
- Day 5
- Append multiple CSV Files from a folder
- Append multiple Excel tables/Sheets from single file
- Append Excel tables with different number of columns
- Append multiple Excel files from a folder
- Append different data source files in Power Query (Power BI )
- Day 6
- Merge Tables/Sheets in Power Query (Power BI)
- Merge Data from multiple Excel Files/Workbooks in Power Query (Power BI)
- Merge Data from different Data Sources in Power Query (Power BI)
- Merge data having multiple matching columns or multiple Criteria in Power Query (Power BI)
- Day 7
- Column from Examples on Splitting Text
- Column from Examples on Merging Text
- Column from Examples on Date Column
- Column from Examples on Alphanumeric Data
- Conditional Column on One Column
- Conditional Column on two columns
- Conditional Column Comparing two column values
- Day 8
- Fill down and Fill up
- Grouping
- Transpose
- Unpivot
- Data Types in Power Query (Power BI)
- Replace Errors and Values
- Keep Rows and Remove Rows
- Add, Remove, Goto Columns
- Day 9
- Introduction to M Language
- M Functions – Date (ISIN)
- M Functions – Date (Add and Subtract)
- M Functions – Date (Day, Month, Week, Year)
- M Functions – Text (Basic)
- Writing a small M code in Power BI
- Day 10
- Understanding Data relationships
- Creating relationships within tables
- Cardinality
- Day 11
- Column Chart
- Stacked Column Chart
- Pie Chart
- Donut Chart
- Funnel Chart
- Ribbon Chart
- Include and Exclude
- Export data from Visual
- Day 12
- Creating a Simple Table
- Formatting in Table
- Conditional Formatting in Table
- Changing Aggregation in Table
- Creating a Matrix in Power BI
- Conditional Formatting in Matrix
- Automatic Hierarchy in Matrix
- Subtotal and Grand Total
- Number Formatting in Table and Matrix
- Day 13
- Line Chart
- Drill down in Line Chart
- Area Chart
- Line vs Column Chart
- Scatter Plot
- Waterfall Chart
- Tree Map
- Gauge Chart
- Day 14
- Number Card
- Text Card
- Date Card
- Multi-Row Card
- Filter on Visual
- Filter on Page
- Filter on All Pages
- Drill through
- Day 15
- Slicer for Text
- Format Text Slicer
- Date Slicer
- Format Date Slicer
- Number Slicer
- Day 16
- Animated Bar Chart Race
- Drill Down Donut Chart
- Drill Down Column Chart
- Word Cloud
- Sankey Chart
- Infographic
- Play Axis
- Scoller
- Sunburst Chart
- Histogram
- Day 17
- What is DAX & Power Pivot?
- Our first DAX measure
- Understanding the Power Pivot Calculation Engine & Evaluation Context
- Formatting the DAX measures
- Reusability of DAX measures
- IF Condition in DAX
- DISTINCTCOUNT in DAX
- MIN / MAX / AVERAGE
- CALCULATE in DAX
- Adding columns with DAX
- Alternate syntax for CALCULATE()
- Variables in DAX
- Day 18
- Creating a Superstore Report
- Create an Account on Power BI Service
- Publish Report to Power BI Service Account
- Export (PPT, PDF, PBIX) Report and Share
- Comment, Share and Subscribe to a report
- Create a dashboard in Power BI Service
Meet Your Trainer
Md. Aksadur Rahman
Microsoft Certified Professional
Python - Book Author
- 19+ years experience in IT Industry
- Lecturer at a Private University in Bangladesh.
- Experience of Project Management, Business Analyst and Coding.
- Combined expertise in industry and classroom.
Expertise Areas:
- Business Analysis, Project Management, User Engagement, Service Operation
- Strategic Business Models
- C# .Net, SQL Server, Python, PHP, MySQL, HTML5
- Systems Management and IT Innovation
- Business Intelligence (BI) Tools
Course Fee & Payment Options
Secure and convenient payment methods available
Course Fee
BDT 3,000
Per Participant
- 12 Hours Live Training
- Course Materials Included
- Certificate of Completion
Payment Methods
Bank Transfer
Direct bank account transfer
Account Name: MEEK Technologies Ltd.
Account Number: 7022-0212000985
Bank: Trust Bank Ltd
Branch: Millennium Corporate Branch, Dhaka
Empowering businesses through innovation since 2016.
© 2026 MEEK Technologies Limited. All rights reserved.