Jason @excel_course

The Truth is.... Bosses don't care how much time you take to clean up your data. He is more interested to know when you can give him the report and how many reports you can give him. Most employees spend 90% of their efforts in cleaning the data and 10%…lnkd.in/gNdS582Q

What's the difference between Data Analytics and Data Analysis? Most people will use the 2 terms interchangeably. But are they really the same? What do you think? To me, they are different. Knowing the difference will guide you in upgrading your skills…lnkd.in/gMWXZ_3e

I just did a training for DAT Power BI Physical Test Drive and this is one of the things I shared with them. DAT refers to Data Arcade Tournament. DAT is a highly anticipated whole-of-government visual analytics competition organised by sG GovTech annua…lnkd.in/g7Jr-Q5A

What is the Taboo of Data Visualization? At least half of the users made this mistake. Do you know what it is? That is editing the original raw files manually. Do you agree? lnkd.in/g9E_4mw #datavisualization #excel #powerbi lnkd.in/dyVAnQ6f

Building a successful Data-Driven L&D Department requires the following 7 Pillars. 1. Data Analyst 2. Data Steward 3. Data Architect 4. Business Intelligence (BI) Specialist 5. Data Governance Manager 6. Data Privacy and Security Officer 7. Training and…lnkd.in/gUh8HHZD

I recently received a call from Clara, who was interested in my course on Secrets Hacks of Excel Data Analytics for PMET. Clara, an HR professional, reached out to me to determine if the course would be suitable for her. Curious about her role, I inquired…lnkd.in/gDzeFd6b

When I travel my family for holiday, i will keep all the paper receipts on the things we spent on. I love to keep track of the expenses as detailed as possible. But I never get to complete the task to the details I want as there are simply too many rece…lnkd.in/gxAciuZs

What is often missing among Pivot Table users to fully harness the power of Data Analytics in Excel? 1. Data Typing and Labeling 2. Scalability 3. Report Versus Data Sources 4. Proper Data Organization 5. Utilizing Power Query 1. Data Typing and Labeli…lnkd.in/gBFq3JNc

A client asked me, why do I have to request real data for the project and not worked with masked data? Here is my answer: Loss of Data Granularity: Masking techniques often involve removing or obfuscating specific details within the dataset, such as pe…lnkd.in/gPMNNBKn

The easiest tool to learn data analytics is Excel. It can help you - Learn how to capture the data in the correct way. - Understand the different data types used. - Analyze the data using Pivot Table - Visualize the results using Pivot Chart - Tell the…lnkd.in/gCS-zKyV

Top 3 Ingredients to Develop a Data-Driven Department 1. Clear Data Strategy 2. Robust Data Infrastructure 3. Skilled Data Talent It is good to start small. Instead of creating a data-driven organization from the start, you can start with a department f…lnkd.in/gK45F9ss

Hiring a developer to create a mobile app for project spending can be costly, with potential expenses exceeding $10K. Additionally, the process of conveying the project requirements to the developer can result in time wasted. Moreover, there's no guarante…lnkd.in/gz4NxryK

PowerApps is a powerful low-code platform developed by Microsoft that allows users to create custom business applications without the need for extensive coding knowledge. It provides a user-friendly interface for designing and building apps that can run o…lnkd.in/g5tVX7hr

A Pivot Table is a powerful tool in Excel that allows you to summarize and analyze large amounts of data quickly and easily. However, to make the most of Pivot Tables, it is important to create a well-organized and structured data source. Here are the key…lnkd.in/g666aCuv

Deployment – "From Lab to Real World: Deploying Your Models"   In the final stage of the CRISP-DM framework, you will be deploying the models and making the insights available to stakeholders. You need to answer questions like: how will stakeholders acces…lnkd.in/g5xYKagV

Evaluation – "Separating the Wheat from the Chaff: Choosing the Best Model for Business Objectives" In the fifth stage of the CRISP-DM framework, you will be evaluating the models and selecting the best one that meets the business objectives. You need to…lnkd.in/gXC3h4-Q

Modeling – "Crunching the Numbers: Selecting the Right Modeling Techniques" In the fourth stage of the CRISP-DM framework, you will be selecting and applying modeling techniques to your data. You need to answer questions like: what algorithms should I us…lnkd.in/gaMmcMZB

Data preparation – "Turning Data into Gold: Preparing Your Data for Modeling"   Data preparation is the third stage of the CRISP-DM framework, where you will be cleaning, transforming, and integrating your data to prepare it for modeling.   Data preparati…lnkd.in/gBGFSVTN

Knowledge is free BUT.... When it comes to acquiring knowledge, there are various sources available for individuals, such as books, online resources, and academic institutions. However, simply having access to this information does not guarantee its usef…lnkd.in/gARU8i8Q

Data understanding – "Uncovering Hidden Insights: Understanding Your Data"   In the second stage of the CRISP-DM framework, you will be exploring and analyzing your data. You need to answer questions like: what data do we have? Is it complete and accurate…lnkd.in/g6wVMv_N