Wednesday, April 14, 2021
  • Setup menu at Appearance » Menus and assign menu to Top Bar Navigation
Advertisement
  • AI Development
    • Artificial Intelligence
    • Machine Learning
    • Neural Networks
    • Learn to Code
  • Data
    • Blockchain
    • Big Data
    • Data Science
  • IT Security
    • Internet Privacy
    • Internet Security
  • Marketing
    • Digital Marketing
    • Marketing Technology
  • Technology Companies
  • Crypto News
No Result
View All Result
NikolaNews
  • AI Development
    • Artificial Intelligence
    • Machine Learning
    • Neural Networks
    • Learn to Code
  • Data
    • Blockchain
    • Big Data
    • Data Science
  • IT Security
    • Internet Privacy
    • Internet Security
  • Marketing
    • Digital Marketing
    • Marketing Technology
  • Technology Companies
  • Crypto News
No Result
View All Result
NikolaNews
No Result
View All Result
Home Data Science

Visually Explained: Three Excel Core-Features Even Excel-Pros Don’t Know

November 29, 2019
in Data Science
Visually Explained: Three Excel Core-Features Even Excel-Pros Don’t Know
585
SHARES
3.3k
VIEWS
Share on FacebookShare on Twitter

Over the last few years, Excel has been redesigned from the ground up. Currently, Microsoft is making the new Excel core-features available to every user, regardless of your Office 365 license. Thanks to the Microsoft naming conventions, it is easy to confuse the new features with existing ones. That being said, Power Query and Power Pivot are not the same things as Pivot Tables, which you have likely been using for years.

You might also like

6 Limitations of Desktop System That QuickBooks Hosting Helps Overcome

Robust Artificial Intelligence of Document Attestation to Ensure Identity Theft

Trends in custom software development in 2021

Power Query (M-Language)
Data preparation is very time-consuming. Power Query allows you to cleanse large amounts of data and make them usable within Excel: for example, a large CSV log file with lots of missing values, weird formats, and errors. Power Query is UI based, it’s easy to learn, and if you want to go the extra mile, you can learn its M-Language, which enables you to write custom scripts to automate data cleansing.

Power Pivot (DAX)
With Power Pivot, you can structure multiple tables into a star schema, with lookup tables and data tables. DAX (Data Analysis Expression) is a language that enables you to analyze data across your entire model. The learning curve is a bit steep, as you need to understand some important foundational concepts before you start using it. However, it’s a good choice if you work with large and complex datasets.

Cognitive Services
If you are a Citizen Data Scientist, and you want to consume machine learning and deep learning capabilities without building and training models yourself, Cognitive Services comes to your rescue. It’s a collection of (cognitive) vision, knowledge, language, search, and speech services, which can be consumed from within Excel via a REST API service. You can, for example, load customer reviews into Cognitive Services, perform a sentiment analysis and load the results back into Excel.

My take on the new Excel core-features
It’s a double-edged sword. On the one hand, Excel is being ramped up for an AI and the big-data-driven world we live in. On the other hand, though, Excel is becoming even harder to use for non-experts. In addition to its two established languages, the regular Excel function language (which has no name) and VBA, you now have to familiarize yourself with two new languages: M-Language and DAX.

What’s the alternative?
Realistically speaking, there is no alternative to Excel in the business world. Embrace the new Excel core-features, but don’t commit to them 100%. Consider using
Python on Jupyter Notebooks in parallel, along with SQL, especially if you have a diverse team with non-technical staff, BI analysts, and data scientists who all need to work jointly on data.

After all, programming (especially Python) is not as hard to learn as most business people fear. If you can handle Excel, you will do well with Python. Just give yourself and your team time to learn. You will benefit greatly from Python libraries such as Pandas, Matplotlib, Sci-Kit, and TensorFlow.

I work in the field of Data & Technology Literacy. Please leave a comment, shoot me an email at [email protected] or reach out to me on LinkedIn.


Credit: Data Science Central By: Rafael Knuth

Previous Post

Philadelphia Eagles Lock Down Kicker Jake Elliot With Foolish Contract

Next Post

Cybersecurity: The web has a padlock problem - and your internet safety is at risk

Related Posts

6 Limitations of Desktop System That QuickBooks Hosting Helps Overcome
Data Science

6 Limitations of Desktop System That QuickBooks Hosting Helps Overcome

April 13, 2021
Robust Artificial Intelligence of Document Attestation to Ensure Identity Theft
Data Science

Robust Artificial Intelligence of Document Attestation to Ensure Identity Theft

April 13, 2021
Trends in custom software development in 2021
Data Science

Trends in custom software development in 2021

April 13, 2021
Epoch and Map of the Energy Transition through the Consensus Validator
Data Science

Epoch and Map of the Energy Transition through the Consensus Validator

April 13, 2021
NetSuite ERP ushering a digital era for SMEs
Data Science

NetSuite ERP ushering a digital era for SMEs

April 12, 2021
Next Post
Cybersecurity: The web has a padlock problem – and your internet safety is at risk

Cybersecurity: The web has a padlock problem - and your internet safety is at risk

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recommended

Plasticity in Deep Learning: Dynamic Adaptations for AI Self-Driving Cars

Plasticity in Deep Learning: Dynamic Adaptations for AI Self-Driving Cars

January 6, 2019
Microsoft, Google Use Artificial Intelligence to Fight Hackers

Microsoft, Google Use Artificial Intelligence to Fight Hackers

January 6, 2019

Categories

  • Artificial Intelligence
  • Big Data
  • Blockchain
  • Crypto News
  • Data Science
  • Digital Marketing
  • Internet Privacy
  • Internet Security
  • Learn to Code
  • Machine Learning
  • Marketing Technology
  • Neural Networks
  • Technology Companies

Don't miss it

Six courses to build your technology skills in 2021 – IBM Developer
Technology Companies

Every stroke matters – IBM Developer

April 14, 2021
Samsung’s new Galaxy Quantum 2 uses quantum cryptography to secure apps
Internet Security

Samsung’s new Galaxy Quantum 2 uses quantum cryptography to secure apps

April 14, 2021
Hackers Using Website’s Contact Forms to Deliver IcedID Malware
Internet Privacy

Hackers Using Website’s Contact Forms to Deliver IcedID Malware

April 14, 2021
Apache Software Foundation retires slew of Hadoop-related projects
Big Data

Apache Software Foundation retires slew of Hadoop-related projects

April 14, 2021
Coinbase IPO marks historic first crypto company to enter US stock exchange as Bitcoin rockets
Blockchain

Coinbase IPO marks historic first crypto company to enter US stock exchange as Bitcoin rockets

April 13, 2021
AI.Reverie Appoints Former NVIDIA Deep Learning Guru Aayush Prakash as Head of Machine Learning
Machine Learning

AI.Reverie Appoints Former NVIDIA Deep Learning Guru Aayush Prakash as Head of Machine Learning

April 13, 2021
NikolaNews

NikolaNews.com is an online News Portal which aims to share news about blockchain, AI, Big Data, and Data Privacy and more!

What’s New Here?

  • Every stroke matters – IBM Developer April 14, 2021
  • Samsung’s new Galaxy Quantum 2 uses quantum cryptography to secure apps April 14, 2021
  • Hackers Using Website’s Contact Forms to Deliver IcedID Malware April 14, 2021
  • Apache Software Foundation retires slew of Hadoop-related projects April 14, 2021

Subscribe to get more!

© 2019 NikolaNews.com - Global Tech Updates

No Result
View All Result
  • AI Development
    • Artificial Intelligence
    • Machine Learning
    • Neural Networks
    • Learn to Code
  • Data
    • Blockchain
    • Big Data
    • Data Science
  • IT Security
    • Internet Privacy
    • Internet Security
  • Marketing
    • Digital Marketing
    • Marketing Technology
  • Technology Companies
  • Crypto News

© 2019 NikolaNews.com - Global Tech Updates