Best computer center

Our Training Programs

computer courses near me,computer center near me

  Tally Prime

  • Introduction to accounts.

  • Introduction to Tally Prime

  • Maintaining chart of Accounts

  • Indirect Tax - Goods & Service Tax

  • Introduction to Inventory System

  • Indirect Tax - Goods & Service Tax

  • Introduction to Inventory

  • Introduction Storage & Classification of Inventory

  • Introduction to Accounts Receivable & Payable Management

  • Introduction to Purchase & Sales Order Management

  • Introduction to Cost/Profit Centres Management

  • Introduction to budgets & Scenarios

  • Introduction to GST

  • Introduction to GST

  • Quarterly Return Monthly Payment Scheme

  • Introduction to TDS

  • Introduction to Management of business data

  • Introduction to Moving to the Next Financial Year

  • Business Case study

  • Introduction to Recording Advanced TDS Transactions

  • Introduction to Interest Calculations

  • Introduction to Payroll & Income tax

computer courses near me,computer center near me ,SAP

  SAP Courses

  • 1. Enterprise Resource Planning (ERP): ERP is a software solution that helps organizations manage their business processes efficiently. It integrates various functions and departments within an organization, such as finance, HR, manufacturing, and inventory, into a unified system, allowing for seamless communication and data sharing.

    2. SAP Navigation: SAP (Systems, Applications, and Products) is a leading ERP software. Navigating SAP involves using a graphical user interface to access various modules and functionalities. Users typically use transaction codes to access specific tasks and data within the SAP system.

    3. SAP FI & CO Overview:

    • SAP FI (Financial Accounting): This module handles financial transactions, accounting, and reporting. It manages general ledger accounting, accounts receivable, accounts payable, asset accounting, and financial statement generation.

    • SAP CO (Controlling): The CO module focuses on internal controlling processes. It includes cost accounting, profitability analysis, budgeting, and variance analysis.

    4. Inventory Management: Inventory management in SAP involves tracking and controlling inventory levels efficiently. It includes tasks like goods receipt, goods issue, stock transfer, and inventory valuation.

    5. Inventory Valuation: Inventory valuation in SAP determines the value of the inventory on the balance sheet. Common methods include standard price, moving average price, and FIFO (First-In, First-Out).

    6. Concept of Consolidation: Consolidation is the process of combining financial data from multiple entities within an organization to create a unified set of financial statements. SAP provides tools and modules for consolidating financial data from different business units or subsidiaries.

    7. SAP Finance Organization Structure & Master Data: SAP FI is organized around various key elements:

    • Company Code: Represents a legally independent entity.
    • Chart of Accounts: Defines the structure of general ledger accounts.
    • Financial Statement Version: Specifies how financial statements are presented.
    • Master Data: Includes essential data like vendors, customers, and accounts.

    8. Financial Statement Versions:

    • Balance Sheet: A financial statement that shows a company's financial position at a specific point in time, displaying assets, liabilities, and equity.

    • Profit & Loss Statement (Income Statement): This statement summarizes a company's revenues, expenses, and profits over a specific period, typically a fiscal year.

    9. SAP Controlling Organization Structure & Master Data: SAP CO uses elements like cost centers, profit centers, and internal orders to organize controlling data. Master data in CO includes cost elements, cost centers, and profit centers, which are essential for cost analysis and reporting.

    10. Concept of Consolidation (Reiterated): Consolidation in SAP CO involves combining financial data from different cost centers, profit centers, or internal orders to gain a holistic view of an organization's financial performance.

    In summary, SAP is a robust ERP system with modules like FI and CO, which are integral for managing financial aspects of a business. Inventory management, valuation, and consolidation play crucial roles in financial data management, while SAP's organizational structures and master data ensure accurate and efficient financial reporting.

  • Introduction to SAP MM (Materials Management):
  • SAP MM is a vital module within the SAP R/3 System, dedicated to managing an organization's materials and inventory. This module plays a crucial role in streamlining procurement, inventory control, and logistics processes.
  • Introduction to ERP (Enterprise Resource Planning): ERP systems are comprehensive software solutions that enable organizations to efficiently manage their various business processes and functions. SAP is a prominent ERP provider known for its versatile modules.
  • SAP Overview: SAP is a leading provider of ERP software, offering a wide range of modules, including SAP MM, designed to enhance business operations.
  • Functions and Objectives of SAP MM: SAP MM serves to optimize procurement, inventory management, and materials-related processes, ensuring cost-effective operations and timely deliveries.
  • Overview Cycle of SAP MM: The SAP MM cycle encompasses processes like procurement, inventory management, and materials planning, ensuring a seamless flow of materials within an organization.
  • Organizational Structure in SAP R/3 System: In the SAP R/3 System, the organizational structure includes elements like Company, Company Code, Plant, Storage Location, Purchasing Organization, and Purchasing Group, which define how materials are managed.
  • Creation of Organizational Elements: Key organizational elements in SAP MM include Company, Company Code, Plant, Storage Location, Purchasing Organization, and Purchasing Group, which are essential for effective materials management.
  • Master Data: Master data in SAP MM comprises Material Master, Vendor Master, Info Record, and Source Determination, serving as the foundation for procurement and inventory management.
  • Source Determination in Purchasing: Source Determination involves selecting the most suitable vendors and sources for procurement, optimizing cost-efficiency and reliability.
  • Purchase Requisition: A Purchase Requisition is a formal request for the procurement of materials or services within an organization.
  • Purchase Order: A Purchase Order is a legally binding document issued by a buyer to a seller, specifying the terms and conditions of a purchase.
  • RFQ – Request for Quotation: RFQ is a document sent to potential suppliers to request price quotes for goods or services.
  • Outline Agreements: Outline Agreements are long-term contracts with suppliers and include various document types like Contracts and Schedule Agreements.
  • Document Types for Purchasing Documents (PR, PO, RFQ, Contract, and Schedule Agreement): Defining document types in SAP MM helps categorize and streamline purchasing documents, optimizing the procurement process.
  • Define Document Type: Configuring document types in SAP MM enables standardized documentation for procurement activities.
  • Define Number Ranges for Document Type: Defining number ranges for document types ensures a systematic and organized approach to managing procurement documents.
  • This optimized content should improve your website's SEO performance by incorporating relevant keywords and phrases related to SAP MM and its associated processes.

Master Data Overview:

Master data serves as the cornerstone of efficient data management within SAP, encompassing vital information about materials, customers, vendors, and more.

Material Master:

The Material Master is a pivotal component of SAP, housing comprehensive data on materials. This information is invaluable for procurement, production, and inventory management.

BOM Configuration and Use in Production Planning:

Bill of Materials (BOM) configuration empowers businesses to create and manage product structures, which are indispensable for effective production planning and assembly.

Routings (Task Lists) Configuration and Use in Production Planning:

Routings, or task lists, define the precise sequence of operations in production processes. They are the linchpin for efficient production planning.

Production Versions and Their Importance:

Production Versions play a pivotal role in managing variant production processes, allowing businesses to adapt to evolving demands and product variations.

Master Planning:

Master Planning encompasses several critical components, including Sales Operations Planning, Demand Management, Long-term Planning, and Forecasting, all aimed at aligning production with customer demand.

Sales Operations Planning:

Sales Operations Planning involves harmonizing sales forecasts with production planning to ensure the timely availability of products to meet customer demand.

Demand Management:

Demand Management plays a crucial role in forecasting and managing customer demand, thereby influencing production planning decisions.

Long-term Planning and Planned Independent Requirements:

Long-term Planning takes into account planned independent requirements to forecast and manage materials over extended periods, enhancing overall stability.

Forecasting Process and MRP Control:

The Forecasting Process and Material Requirements Planning (MRP) work hand in hand to optimize inventory levels and production scheduling. Real-world examples bring these processes to life.

Production Schedule (MPS):

Master Production Scheduling (MPS) acts as the compass for maintaining a balanced production plan that can meet the ever-changing demands of customers.

MRP Run Configuration and Evaluation Tools:

Configuring MRP runs and leveraging evaluation tools are essential for optimizing materials planning and replenishment, ensuring efficiency in operations.

Consumption-Based Planning:

Consumption-Based Planning relies on actual consumption data to trigger procurement and production activities, keeping inventory levels in check.

Lot Size Procedures and Real Business Process Example:

Lot Size Procedures determine order quantities, and real-world examples illustrate their practical application in the production context.

Discrete Manufacturing:

Discrete Manufacturing involves the assembly of products from individual components, each with specific master data configurations tailored to their unique purposes.

Integration of SAP PP with Other SAP Modules:

SAP PP seamlessly integrates with other SAP modules such as Material Management (MM), Sales and Distribution (SD), Quality Management (QM), and Plant Maintenance (PM) to enable comprehensive and cohesive business operations.

Repetitive Manufacturing:

Repetitive Manufacturing streamlines high-volume production processes through specific master data and planning techniques, including Backflushing and the REM (Repetitive Manufacturing) processes.

  • Introduction to SAP SD:
  • SAP SD, short for Sales and Distribution, is a vital module within SAP ERP (Enterprise Resource Planning) that focuses on managing the sales and distribution processes of an organization. It plays a critical role in ensuring efficient order-to-cash and delivery-to-payment processes.
  • Introduction to ERP:
  • Enterprise Resource Planning (ERP) systems are integrated software solutions that facilitate the management of core business processes, including finance, manufacturing, human resources, and, in this case, sales and distribution. SAP is a leading provider of ERP solutions.
  • SAP Overview:
  • SAP (Systems, Applications, and Products) is a global leader in enterprise software that offers a wide range of business solutions, including SAP SD, to help organizations streamline their operations, improve productivity, and make data-driven decisions.
  • Functions and Objectives of SAP SD:
  • The primary functions of SAP SD include managing sales processes, order processing, pricing, delivery, billing, and customer relationship management. Its objectives are to enhance sales efficiency, customer satisfaction, and revenue generation.
  • Overview Cycle of SAP SD:
  • The SAP SD cycle encompasses the entire sales process, from initial customer inquiry to order creation, delivery, billing, and payment receipt. Understanding this cycle is crucial for effectively managing sales operations.
  • Organizational Structure in SAP ECC:
  • In the SAP ECC system, businesses establish a structured organization that includes elements like the company, company code, plant, storage location, sales organization, distribution channel, sales office, sales group, and their respective assignments.
  • Navigation Basics:
  • Navigating through SAP is made easier with features like Easy Access, Favorites, and Settings, allowing users to efficiently access frequently used functions and personalize their experience.
  • Creation of Organizational Elements:
  • Setting up key organizational elements such as company, company code, plant, and others is a foundational step in configuring SAP SD to align with an enterprise's structure and operations.
  • Master Data:
  • Managing master data is essential in SAP SD. This includes maintaining the Material Master, Customer Master, and Customer Material Information records to ensure accurate and efficient order processing.
  • Pricing Process and Determination:
  • The pricing process in SAP SD involves configuring conditions, access sequences, condition types, pricing procedures, and determining the appropriate pricing conditions for sales orders and invoices.
  • Document Types for Pre-sales and Sales Documents:
  • SAP SD utilizes various document types such as Inquiry (IN), Quotation (QT), Order (OR), Contract (QC), and others. Properly defining and configuring these document types is essential for sales order management.
  • Sales Cycles - Sales Processes:
  • SAP SD encompasses multiple sales processes, including Sales Inquiry, Sales Quotation, Contracts Processing, Sales Order, Delivery and Shipping, Invoicing, Credit and Debit Memo, Credit Sales, Cash Sales, and Rush Order.
  • Free Goods Processing:
  • Understanding Free Goods Processing in SAP SD, including the condition technique and exclusive versus inclusive free offers, is crucial for managing promotions and discounts.
  • Revenue Account Determination:
  • Integration of SAP SD with Financial Accounting and Controlling (FI/CO) is vital for accurate revenue account determination and G/L (General Ledger) account assignments.
  • SD Basic Functions:
  • These functions include partner determination, output determination, text determination, material determination, availability checks, incompletion checks, listing and exclusion, route determination, and working with Bill of Materials.
  • Special Sales Processes:
  • Special sales processes in SAP SD encompass Consignment Sales, Stock Transport Orders, Third-Party Processing, Returnable Transport Packaging (RTP), Intercompany Sales, and Rebates Processing.
  • Invoicing Plans:
  • Managing invoicing plans involves periodic invoicing and milestone billing, allowing businesses to bill customers based on specific milestones achieved during the project or order.
  • Variant Configuration:
  • Variant Configuration in SAP SD is used for complex product configurations. It involves setting up variants, variant pricing, and testing various scenarios.
  • Integration with Other Modules and Support:
  • SAP SD seamlessly integrates with other SAP modules, including Financial Accounting/Controlling (FI/CO), Materials Management (MM), and Production Planning (PP). Additionally, handling IDocs, batch jobs, support projects, and implementation projects are crucial aspects of SAP SD operations.

Digital Marketing 

  • Types of Marketing Concepts
  • In the dynamic world of marketing, various concepts have evolved over time to guide businesses in their strategies and approaches. These concepts reflect different philosophies on how to engage with customers and drive business success. Let's explore the five main types of marketing concepts:
  • 1. Production Concept
  • The production concept centers on the idea that consumers primarily seek products that are widely available and affordable. In this approach, businesses focus on mass production and efficiency to reduce costs and make products accessible to a broad audience. While this concept can lead to cost-effective offerings, it may overlook customer preferences and evolving market demands.
  • 2. Product Concept
  • The product concept revolves around the belief that customers prioritize high-quality and innovative products. Businesses adhering to this concept invest heavily in product development and improvement, aiming to deliver superior offerings that can outperform competitors. However, this concept may overlook other essential aspects like customer needs and marketing strategies.
  • 3. Selling Concept
  • The selling concept assumes that customers won't buy products unless persuaded through aggressive sales and promotional efforts. Businesses adopting this approach focus on sales tactics, such as advertising and personal selling, to convince customers to make purchases. While it can be effective for short-term gains, it may not foster long-term customer relationships.
  • 4. Marketing Concept
  • The marketing concept is customer-centric, emphasizing the identification of customer needs and wants. Businesses following this philosophy prioritize understanding their target audience and delivering products or services that satisfy those desires. They strive to create value for customers and build long-term relationships based on trust and customer satisfaction.
  • 5. Societal Marketing Concept
  • The societal marketing concept extends beyond customer satisfaction to consider broader societal well-being. It advocates for businesses to make decisions that not only benefit their bottom line but also have a positive impact on society and the environment. This concept aligns with the growing importance of corporate social responsibility (CSR) and sustainability in modern business practices.
  • In summary, each of these marketing concepts represents a different approach to engaging with customers and achieving business goals. The choice of which concept to adopt depends on various factors, including the nature of the product or service, the target market, and the company's values. Successful businesses often combine elements from multiple concepts to create a holistic marketing strategy that meets both customer needs and societal expectations.
  • By understanding and applying these marketing concepts effectively, businesses can optimize their marketing efforts, enhance customer relationships, and ultimately improve their online visibility and search engine rankings.
 
 
  • Keyword research on different areas according to your business
  • Use headline analyzer
  • Yoast for SEO on WordPress
  • Write a copy that follows SEO & readability instructions
  • Work with search engines
  • Drive traffic to your webpage
  • TOOLS USED IN THE COURSE
  • Google Keyword Tool
  • Google Analytics
  • Google Search Console
  • Yoast SEO for WordPress SEO and blogger SEO
  • A number of 3rd party Google research tools including tools to research competition
  • Twitter marketing
  • YouTube marketing
  • Google Ads
  • Google Analytics
  • Linkedin Marketing 
  • How to Build an Email List from Scratch and apply the right strategies to grow it to thousands of subscribers and customers.
  • lHow to Plan successful email campaigns
  • How to Create irresistible Lead Magnets that attracts thousands of clients
  • How to Create an optimized landing page that converts
  • And Advanced strategies like Email automation And A/B testing
  •  
  • What Is Affiliate Marketing?
  • Why Is Affiliate Marketing So Popular?
  • How Does Affiliate Marketing Work?
  • How Businesses Use Affiliate Marketing
  • How Affiliates Promote Products and Services
  • How Are Affiliates Paid?
  • Create A Powerful WordPress Website For Marketing (Using A Theme)

    Create Slider, Call To Actions, Landing Pages, Garbing Email Forms For Email Marketing, Store, Products And Much More

Programming Courses

  • C programming Introduction of Programming Languages
  • Tokens3
  • Control Statement and Expressions
  • Concept of LoopArrays and StringFunctions
  • PointersStructure and Unions
  • Dynamic Memory Allocation

  • C++
  • Introduction to Object Oriented Programming‘C++’
  • Tokens and Type CastingClasses & ObjectsFunction in ‘C++’
  • Constructors and DestructorOperator Overloading
  • Inheritance
  • Working with files, Exception Handling
  • Introduction To JAVA
  • Introduction to Java
  • The Java Environmen
  • Basic Language Elements
  • Object Oriented Programming
  • Extending Classes and Inheritance
  • Package
  • Exception Handling:
  • Array & String :
  • Thread :
  • A Collection of Useful Classes
  • GUI Programming
  • Event Handling
  • Database Programming using JDBC
  • Introduction to Python and Computer Programming
  • Data Types, Variables, Basic Input-Output Operations, Basic Operators
  • Boolean Values, Conditional Execution, Loops, Lists and List Processing, Logical and Bitwise Operations
  • Functions, Tuples, Dictionaries, and Data Processing
  • Modules, Packages, String and List Methods, and Exceptions
  • The Object-Oriented Approach: Classes, Methods, Objects, and the Standard Objective Features; Exception Handling, and Working with Files

 

  • Webdesiging Modules
  • l HTML
  • HTML 5
  • PHP
  • SQL
  • MYSQL
  • Javascript
  • WordPress 

Graphic Design & Multimedia Courses

Getting started with Photoshop

Navigating and customizing  the workspace

Using the Photoshop layers panel

Editing RAW and non-RAW photos in Photoshop

Using selection tools

Using tools like doge and burn to edit just part of your images

Retouching photos such as whitening teeth, removing blemishes, and more

Creating and adjusting shapes in Photoshop

Designing graphics with different blend modes

Adding and editing layer styles like bevels and drop shadows

Adding artistic filters like blurs

Adding and editing text to your graphics,Saving your projects for anything - printing, online

 

 

Adobe Illustrator

  • Intro to Adobe Illustrator

  • Exploring the interface

  • Choosing a workspace

  • Opening a file Using artboards

  • Changing your view

  • Zooming and scrolling Using tools and panels

  • Painting using Illustrator

  • Color modes and their switches; creation of custom colors

  • Illustrator Output Options

  • Export Options

  • Exporting in PDF

  • Print File Format and Proof Setup Option

  • Vector Shapes and Fills

  • Creating Shape

  • Gradients and Pattern

  • Fill Edges

  • Compound Shapes

  • Lines and Pen Tool Creating

  • Curves Modifying Shapes

  • Adding and Formatting Text

  • Paragraph formatting

  • Using paragraph and character styles,

  • Editing styles Putting text on a path

  • Creating outlines

  • Saving as a JPEG

  • JPEG

  • Optimizing JPEGs

Adobe Indesign

  • Intro to Adobe indesign

  • Exploring the interface

  • Choosing a workspace

  • Opening a file Using artboards

  • Changing your view

  • Zooming and scrolling Using tools and panels

  • Painting using Illustrator

  • Color modes and their switches; creation of custom colors

  • Illustrator Output Options

  • Export Options

  • Exporting in PDF

  • Print File Format and Proof Setup Option

  • Vector Shapes and Fills

  • Creating Shape

  • Gradients and Pattern

  • Fill Edges

  • Compound Shapes

  • Lines and Pen Tool Creating

  • Curves Modifying Shapes

  • Adding and Formatting Text

  • Paragraph formatting

  • Using paragraph and character styles,

  • Editing styles Putting text on a path

  • Creating outlines

  • Saving as a JPEG

  • JPEG

  • Optimizing JPEGs

  • JPEG Smoothing Selective Quality

  • Saving as a PNG

  • Web PNG Optimizing PNGs

  • Getting comfortable with After Effects CC

  • Starting a new composition

  • Using the basic tools

  • Working in the After Effects CC timeline

  • Adding shape and text layers

  • Animating position, scale, rotation, and opacity

  • Working with shape layers and masks

  • Real world projects such as lower thirds and bumpers

  • Motion graphics principles and best practices

  • Using video effects and presets to speed up workflow

  • Green screen and chromakey removal

  • Visual effects and rotoscoping

  • Motion tracking and video stabilization

  • Creating unique transitions

  • l Exporting your projects

  • Starting a project

  • Editing your videos

  • Adding video and audio transitions

  • Adding professional and modern titles (even some with motion)

  • Improving audio and finding great free music for your projects

  • Correcting and grading the color of your video to give it a great style

  • Adding visual effects to your projects

  • Editing green screen (chroma key) footage

  • Exporting your video for high-quality playback on any device

  • Advanced editing skills

  • Advanced color grading

  • Advanced efficiency tips

  • Introduction to CorelDRAW & graphic design
     CorelDRAW workspace tour, Interface CorelDRAW

  • Document handling (CorelDRAW basics)
    How to use toolbox & property bar commands
    Working with pick tools flyout
    Zoom tool & pan tool (zoom in, zoom out, fit to page/ to page width/ to page height/ to contents/ to selection)
    Curve tools : Freehand tool, 2- point line tool, Bezier tool, pen tool, B-spline tool, Polyline tool, 3- point curve tool
    Drawing tools & properties
    How to Use Effects and Bitmaps Commands

  • Rectangle tools (rectangle, 3- point rectangle)
    Ellipse tools (ellipse, 3- point ellipse) honest
    Shapes tools ( polygon, star, spiral, common shapes, impact tool, graph paper)
    Designing Business Card
    Designing Flyers
    Designing bi fold Brochure
    Logo designing 

computer courses near me,computer center near me , SAP

Microsoft Certifications

  • Creating Dynamic Microsoft Word Documents

  • Effectively Formatting a Document with Styles

  • Prepare Documents for Printing and Exporting

  • Manage Large Documents

  • Working with Page and Section Breaks

  • Control Page Orientation

  • Create and Manage Table Layouts

  • Work with Tab Stops to Align Content Properly

  • Insert Media and Images

  • Perform Mail Merges to create Mailing Labels and Form Letters

  • Build and Deliver Word Forms

  • Manage Templates

  • Protect Documents from Edits

  • Track and Accept/Reject Changes to a Document

  • Build Dynamic Table of Contents

  • Create slides and presentations from scratch

  • Work professionally with Microsoft PowerPoint

  • Develop slides following design principles

  • Use new tools to speed up the creation of presentations

  • Engage your audience using questions and programs such as Kahoot or Mentimeter

  • Give a coherent storytelling to your presentation

  • Differentiate and apply several design styles

  • Create carousels and background presentations

  • Create complex animated videos

 

  • Creating effective spreadsheets

  • Managing large sets of data

  • Mastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)

  • Create dynamic report with Excel PivotTables

  • Unlock the power and versatility of Microsoft Excel's Add-In, PowerPivot, Audit Excel Worksheet formulas to ensure clean formulas

Excel  functions, 

formulas, charts, 

pivot tables, 

conditional formatting

 

VBA

  • Subroutines, variables, data types

  • Core VBA programming concepts

  • VBA functions and more challenging concepts

  • Macros, recordings and enhancing them

  • Debugging and error handling

  • Essential VBA operations

  • Events

  • Managing your VBA code

  • Classes and Object-based programming

 

POWER BI OBJECTIVE

1: Connect & Transform the Raw Data

  • Intro to the Power BI Query Editor

  • Types of Power BI Data Connectors

  • Basic Table Transformations

  • Text, Number & Date Tools

  • Index & Conditional Columns

  • Grouping & Aggregating Data

  • Pivoting & Unpivoting

  • Modifying, Merging & Appending Queries

  • Connecting to Folders

  • Defining Hierarchies & Categories

  • Query Editing & Power BI Best Practices

 

POWER BI OBJECTIVE #2: Build a Relational Data Model

  • Intro to Database Normalization

  • Data ("Fact") Tables vs. Lookup ("Dimension") Tables

  • Creating Power BI Table Relationships

  • "Star" vs. "Snowflake" Schemas

  • Active vs. Inactive Relationships

  • Relationship Cardinality

  • Connecting Multiple Data Tables

  • Filtering & Cross-Filtering

  • Hiding Fields from the Power BI Report View

  • Data Modeling & Power BI best Practices

 

POWER BI OBJECTIVE #3: Add Calculated Fields with DAX

  • Intro to Data Analysis Expressions (DAX)

  • Calculated Columns vs. Measures

  • Row Context vs. Filter Context in Power BI

  • DAX Syntax & Operators

  • Common Power BI Functions

  • Basic Date & Time Formulas

  • Logical & Conditional Statements

  • Text, Math & Stats Functions

  • Joining Data with RELATED

  • CALCULATE, ALL & FILTER Functions

  • DAX Iterators (SUMX, AVERAGEX)

  • Time Intelligence Formulas

  • DAX & Power BI Best Practices

 

POWER BI OBJECTIVE #4: Design Interactive Power BI Reports

  • Intro to the Power BI Report View

  • Adding Basic Charts to Power BI Reports

  • Formatting & Filtering Options

  • Matrix Visuals

  • Slicers & Timelines

  • Cards & KPIs

  • Power BI Map Visuals (Basic, Fill, ArcGIS)

  • Treemaps, Lines, Areas & Gauges

  • Editing Report interactions

  • Adding Drillthrough Filters

  • Linking to Report Bookmarks

  • Using "What-If" Parameters

  • Managing & Viewing Roles

  • PREVIEW: Publishing to Power BI Service

  • Power BI Data Viz Best Practices