UrbanPro
true

Find the best tutors and institutes for Data Modeling

Find Best Data Modeling Training

Please select a Category.

Please select a Locality.

No matching category found.

No matching Locality found.

Outside India?

Search for topics

Data Modeling Updates

Ask a Question

Post a Lesson

All

All

Lessons

Discussion

Lesson Posted on 15/12/2017 IT Courses/BI Reporting IT Courses/Big Data Functional Training/Business Analysis Training +11 IT Courses/Data Modeling IT Courses/Data Analysis IT Courses/Database Training IT Courses/MS Office Software Training/MS Access IT Courses/MS Office Software Training IT Courses/MS SQL IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft Power BI IT Courses/MS Office Software Training/Microsoft PowerPoint Training IT Courses/Microsoft Training less

What Is Power Query?

iTech Analytic Solutions

"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...

Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of the Excel add-ins provided as part of Microsoft Power BI self-service solution. Power Query is an Excel add-in that can be used for data discovery,... read more

Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of the Excel add-ins provided as part of Microsoft Power BI self-service solution.

Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of the Excel add-ins provided as part of Microsoft Power BI self-service solution.

You can think of an ETL tool built into your familiar Excel to search or discover data from a wide variety of data sources (both from your enterprise as well as from online public data sources). Power Query has an intuitive and interactive user interface which can be used to search, discover, acquire, combine, refine, transform and enrich the data.

Getting Started with Power Query for Excel:

Power Query allows users to search or discover data across the enterprise or from valuable public data sources available online as well as from a variety of other data sources. It allows you to bring in data into Excel from virtually any type of data sources as listed below:

From the web:

i. From a file: Excel, CSV, XML, Text or Folder that contains files with metadata and links.

ii. From a database: SQL Server, Windows Azure SQL Database, Access, Oracle, IBM DB2, MySQL, PostgreSQL and Teradata.

iii. From other data sources: SharePoint List, OData feed, Windows Azure Marketplace, Hadoop Distributed File System - HDFS, Windows Azure Blob storage, Windows Azure Table storage, Active Directory and Facebook.

Apart from the above data sources, Power Query allows you to search data publicly available online or published data from your organization. This online search of data, along with data integration from the above types of data sources, makes it a real quick ETL tool built right inside your Excel.

read less
Comments
Dislike Bookmark

Lesson Posted on 20/11/2017 IT Courses/BI Reporting IT Courses/Big Data Functional Training/Business Analysis Training +10 IT Courses/Data Analysis IT Courses/Data Modeling IT Courses/Database Training IT Courses/MS Office Software Training/MS Access IT Courses/MS Office Software Training IT Courses/MS SQL IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft Power BI IT Courses/MS Office Software Training/Microsoft PowerPoint Training less

Microsoft Outlook

iTech Analytic Solutions

"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...

Microsoft Outlook is the preferred email client used to access Microsoft Exchange Server email. Not only does Microsoft Outlook provide access to Exchange Server email, but it also includes contact, calendaring and task management functionality. Companies can also integrate Outlook with Microsoft’s... read more

Microsoft Outlook is the preferred email client used to access Microsoft Exchange Server email. Not only does Microsoft Outlook provide access to Exchange Server email, but it also includes contact, calendaring and task management functionality. Companies can also integrate Outlook with Microsoft’s SharePoint platform to share documents, project notes, collaborate with colleagues, send reminders and much more. 

Microsoft Outlook may be used as a standalone application, but is also part of the Microsoft Office suite. Outlook’s current version is Microsoft Outlook 2010. Outlook is also available for the Apple Mac; its current version is Outlook 2011. 

Outlook 2013 includes a few new improvements:

An Unread button: Allows the end user to easily see only those messages marked as unread.

Message preview: Allows the end user to preview the first line of an email from the message list view.

A Zoom slider: Allows the end user to easily increase the font size for individual emails.

Attachment reminders: Reminds the end user when an attachment is referenced in the body of a message.

The Outlook 2013 weather bar: Weather reports for locations selected by the end user.

Outlook 2013 may be used in conjunction with Microsoft SharePoint as long as Exchange 2013 and SharePoint 2013 are properly configured. Additionally, administrators can now control OST file size via the Outlook 2013 sync slider and startup time is improved via the Exchange Fast Access feature.

read less
Comments
Dislike Bookmark

Lesson Posted on 20/11/2017 IT Courses/BI Reporting IT Courses/Big Data Functional Training/Business Analysis Training +11 IT Courses/Data Analysis IT Courses/Data Modeling IT Courses/Database Training IT Courses/MS Office Software Training/MS Access IT Courses/MS Office Software Training IT Courses/MS SQL IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft Power BI IT Courses/MS Office Software Training/Microsoft PowerPoint Training IT Courses/Microsoft Training less

Mail Merge In Word

iTech Analytic Solutions

"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...

Mail Merge is a useful tool that allows you to produce multiple letters, labels, envelopes, name tags, and more user information stored in a list, database, or spreadsheet. Mail Merge is most often used to print or email form letters to multiple recipients. Using Mail Merge, you can easily customize... read more

Mail Merge is a useful tool that allows you to produce multiple letters, labels, envelopes, name tags, and more user information stored in a list, database, or spreadsheet.

Mail Merge is most often used to print or email form letters to multiple recipients. Using Mail Merge, you can easily customize form letters for individual recipients. Mail merge is also used to create envelopes or labels in bulk.

Mail merge is a feature within most data processing applications that enables users to send a similar letter or document to multiple recipients. It enables connecting a single form template with a data source that contains information about the recipient’s name, address and other pre-defined and supporting data.

Mail merge primarily enables automating the process of sending bulk mail to customers, subscribers or general individuals. Mail merge works when a data file is stored that includes the information of the recipients to whom the letter will be sent. This file can be a spreadsheet or database file containing separate fields for each different type of information to be merged within the letter.

The second file is the word document or the letter template. The recipient’s information on the letter template is kept empty. When the mail merge process is initiated, the recipient's data from spreadsheet or database is fetched and placed within the empty field in the letter, one by one, until all letters are created.

read less
Comments
Dislike Bookmark

Looking for Data Modeling Training

Find best Data Modeling Training in your locality on UrbanPro.

FIND NOW

Lesson Posted on 05/09/2017 IT Courses/Data Modeling IT Courses/ERWIN Autosys IT Courses/Data Warehouse

Data Modeling Training Video

Kriti C.

I have 12+ years of experience as a working professional and trainer. I have expertise in Analytics domain...

Comments
Dislike Bookmark

Lesson Posted on 31/08/2017 IT Courses/Data Warehouse IT Courses/Data Modeling IT Courses/ETL

Datawarehouse: Bill Inmon Vs. Ralph Kimball

Kriti C.

I have 12+ years of experience as a working professional and trainer. I have expertise in Analytics domain...

In the data warehousing field, we often hear about discussions on where a person / organization's philosophy falls into Bill Inmon's camp or into Ralph Kimball's camp. We describe below the difference between the two.Bill Inmon's paradigm: Data warehouse is one part of the overall business intelligence... read more

In the data warehousing field, we often hear about discussions on where a person / organization's philosophy falls into Bill Inmon's camp or into Ralph Kimball's camp. We describe below the difference between the two.

Bill Inmon's paradigm: Data warehouse is one part of the overall business intelligence system. An enterprise has one data warehouse, and data marts source their information from the data warehouse. In the data warehouse, information is stored in 3rd normal form.

Ralph Kimball's paradigm: Data warehouse is the conglomerate of all data marts within the enterprise. Information is always stored in the dimensional model.

read less
Comments
Dislike Bookmark

Lesson Posted on 31/12/2016 IT Courses/BI Reporting IT Courses/Big Data Functional Training/Business Analysis Training +11 IT Courses/Data Analysis IT Courses/Data Modeling IT Courses/Database Training IT Courses/MS Office Software Training IT Courses/MS SQL IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools IT Courses/Microsoft Training IT Courses/MS Office Software Training/MS Access IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft Power BI IT Courses/MS Office Software Training/Microsoft PowerPoint Training less

10 Best Job Interview Tips for Jobseekers

iTech Analytic Solutions

"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...

10 Best Job Interview Tips for Jobseekers:- 1. Conduct Research on the Employer, Hiring Manager, and Job Opportunity2. Review Common Interview Questions and Prepare Your Responses3. Dress for Success4. Arrive on Time, Relaxed and Prepared for the Interview5. Make Good First Impressions6. Be Authentic,... read more

10 Best Job Interview Tips for Jobseekers:-

1. Conduct Research on the Employer, Hiring Manager, and Job Opportunity
2. Review Common Interview Questions and Prepare Your Responses
3. Dress for Success
4. Arrive on Time, Relaxed and Prepared for the Interview
5. Make Good First Impressions
6. Be Authentic, Upbeat, Focused, Confident, Candid, and Concise
7. Remember the Importance of Body Language
8. Ask Insightful Questions.
9. Sell Yourself and then Close the Deal
10. Thank Interviewer(s) in Person, by Email, or Postal Mail.

read less
Comments
Dislike Bookmark

Lesson Posted on 31/12/2016 IT Courses/BI Reporting IT Courses/Big Data Functional Training/Business Analysis Training +9 IT Courses/Data Analysis IT Courses/Data Modeling IT Courses/Database Training IT Courses/MS Office Software Training IT Courses/MS SQL IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools IT Courses/Microsoft Training IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/MS Office Software Training/MS Access less

5 Tips For Improving Your Documentation Immediately.

iTech Analytic Solutions

"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...

Tip 1) Quit it with the Passive Voice The passive voice is a plague on effective documentation. It reduces its clarity, its consistency, and the efficiency and tightness of the writing. The passive voice is writing in which the subject of the sentence denotes the recipient of the action rather than... read more

Tip 1) Quit it with the Passive Voice

The passive voice is a plague on effective documentation. It reduces its clarity, its consistency, and the efficiency and tightness of the writing. The passive voice is writing in which the subject of the sentence denotes the recipient of the action rather than the performer. For example, “the server was installed” represents the passive voice while “the technician installed the server” represents the active voice. The passive voice is more common in most documentation because it is an easier, sloppier way of writing.

Writing in the passive voice is highly detrimental to documentation, especially to process related documentation where it is essential to understand which people or systems are performing the actions. The good news is that this is an easy fix. Under your Grammar function in Word, you can click on the “Passive Sentences” option and Word will automatically check for passive sentences for you.

To improve your documentation immediately: Use the Passive Voice grammar check function in Word to review your documentation and to change passive sentences into clearer, sharper active sentences.

Tip 2) Use Simple Visuals to Engage your Reader

You might not be a graphic artist, but you can improve your documentation quickly through using simple visuals. Take advantage of the many canned Shapes and Smart Art in Word to add a little “punch” to your documentation to better engage your audience.

If you have Microsoft Visio, then take advantage of the many ways that this program offers to draw simple diagrams which reduce your need for extensive text and which improve your chances of stakeholder engagement. One diagram that is particularly useful is the swim lane diagram which illustrates actors and their actions. Without being a process expert, you will be surprised how the simple Swim Lane will improve clarity in roles, responsibilities, and processes for your team and your organization overall.

To improve your documentation immediately: Create visuals in your documentation to illustrate your key messages, replace blocks of text, and to hold your readers’ attention.

Tip 3) Use Great Titles and Bullets

Remember, your audience generally wants to exert as little as energy as possible when reading your work. They’ll just “skim” your document looking for the main points. So, make things easy for them! Headers and bullets, often combined with effective visuals, are as important as the text. For some readers, headers and bullets are all that they will read.  Your reader might even make a decision about your work just by reading the table of contents. So, when assessing your documentation, it’s helpful if the entire gist of your work is communicated by the headers and bullets alone. Does the reader understand what you are trying to say? If they can understand most of what you are saying just by reading the headers, then you have done a good job.

To improve your documentation immediately: Revise your headers and bullets to summarize the whole document.

Tip 4) Tame your Acronyms and Buzz Words

There is perhaps nothing more annoying when it comes to documentation than walking onto a project or into a new organization and to be unable to understand a single paragraph in the document, because it is so full of acronyms and buzz words. Acronyms and buzz words do not, let me repeat, make you sound smarter. In most cases, they actually annoy your reader through hindering her ability to grasp your key messages.

Avoid using excessive acronyms and buzz words whenever possible. Or at least, define them upfront. In many cases, you should define acronyms and frequently used words in a well thought-out Glossary at the beginning of your documents or as part of your documentation library.

To improve your documentation immediately: Learn to tame your use of excessive acronyms and buzz words. If you need to use them, then make sure that you define them upfront at the beginning of your documents or documentation library.

Tip 5) Use the Reperformance Standard

One of the key challenges that organizations face in developing and maintaining excellent documentation is that they do not have a consistent standard for assessing their documentation. In reality, there are many different types of and uses for documentation and using one consistent standard is difficult. There is however one standard that provides a strong metric for most documentation. This standard is called the “reperformance standard”.

The reperformance standard states that the documentation must enable a user to “reperform” the related task or process. That is, the documentation must have sufficient detail and communicate with enough clarity through its text or visuals as a standalone document to allow the user to execute the steps. Although more commonly used by assurance and audit professionals, the reperformance standard can be expanded to many other applications within organizations, including training materials, user manuals, process documentation, and disaster recovery documentation. So, test the quality of your documentation against this standard and challenge yourself to ensure that you are meeting it.

To improve your documentation immediately: Review your document and ask: can someone else reperform these tasks based on what is written here?  If the answer is no – revise it so they can.

read less
Comments
Dislike Bookmark

Lesson Posted on 31/12/2016 IT Courses/BI Reporting IT Courses/Big Data Functional Training/Business Analysis Training +11 IT Courses/Data Analysis IT Courses/Data Modeling IT Courses/Database Training IT Courses/MS Office Software Training/MS Access IT Courses/MS Office Software Training IT Courses/MS SQL IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft Power BI IT Courses/MS Office Software Training/Microsoft PowerPoint Training IT Courses/Microsoft Training less

Microsoft Word

iTech Analytic Solutions

"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...

Microsoft Word is a widely used commercial word processor designed by Microsoft. Microsoft Word is a component of the Microsoft Office suite of productivity software, but can also be purchased as a stand-alone product. It was initially launched in 1983 and has since been revised numerous times. Microsoft... read more

Microsoft Word is a widely used commercial word processor designed by Microsoft. Microsoft Word is a component of the Microsoft Office suite of productivity software, but can also be purchased as a stand-alone product.

It was initially launched in 1983 and has since been revised numerous times. Microsoft Word is available on both Windows and Macintosh operating systems.

Microsoft Word is often called simply Word or MS Word.

In 1981, Microsoft hired Charles Simonyi to develop a word-processing application. The first version was released in 1983. It was not initially popular, owing to its radically different look compared to WordPerfect, the leading word processor at that time. However, Microsoft improved Word continually over the years, including a 1985 version that could run on a Mac. The second major release of Word, in 1987, included an upgrade of major features in addition to new functionalities such as support for the rich text format (RTF).

In 1995, with the release of Windows 95 and Office 95, which offered a bundled set of office productivity software, sales of Microsoft Word increased significantly.
Microsoft Word offers several features to ease document creation and editing, including:

  • WYSIWYG (what-you-see-is-what-you-get) display: It ensures that everything you see on screen will appear the same way when printed or moved to another format or program.
  • Spell check: Word comes with an built-in dictionary for spell checking; misspelled words are marked with a red squiggly underline. Sometimes, Word auto-corrects an obviously misspelled word or phrase.
  • Text-level features such as bold, underline, italic and strike-through
  • Page-level features such as indentation, paragraphing and justification
  • External support: Word is compatible with many other programs, the most common being the other members of the Office suite.

The default file format was .doc prior to the Microsoft Word 2007 version; in 2007, .docx became the default file format.

read less
Comments
Dislike Bookmark

Lesson Posted on 30/12/2016 IT Courses/BI Reporting IT Courses/Big Data Functional Training/Business Analysis Training +11 IT Courses/Data Analysis IT Courses/Data Modeling IT Courses/Database Training IT Courses/MS Office Software Training/MS Access IT Courses/MS Office Software Training IT Courses/MS SQL IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft Power BI IT Courses/MS Office Software Training/Microsoft PowerPoint Training IT Courses/Microsoft Training less

What is a SQL join?

iTech Analytic Solutions

"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...

A SQL join is a Structured Query Language (SQL) instruction to combine data from two sets of data (e.g. two tables). Before we dive into the details of a SQL join, let’s briefly discuss what SQL is, and why someone would want to perform a SQL join. SQL is a special-purpose programming language... read more

A SQL join is a Structured Query Language (SQL) instruction to combine data from two sets of data (e.g. two tables). Before we dive into the details of a SQL join, let’s briefly discuss what SQL is, and why someone would want to perform a SQL join.

SQL is a special-purpose programming language designed for managing information in a relational database management system (RDBMS). The word relational here is key; it specifies that the database management system is organized in such a way that there are clear relations defined between different sets of data.

Typically, you need to extract, transform, and load data into your RDBMS before you’re able to manage it using SQL, which you can accomplish by using a tool like Stitch.

read less
Comments
Dislike Bookmark

Looking for Data Modeling Training

Find best Data Modeling Training in your locality on UrbanPro.

FIND NOW

Lesson Posted on 30/12/2016 IT Courses/BI Reporting IT Courses/Big Data Functional Training/Business Analysis Training +11 IT Courses/Data Analysis IT Courses/Data Modeling IT Courses/Database Training IT Courses/MS Office Software Training/MS Access IT Courses/MS Office Software Training IT Courses/MS SQL IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/Microsoft Training/Microsoft BI (Business Intelligence) Tools/Microsoft Power BI IT Courses/MS Office Software Training/Microsoft PowerPoint Training IT Courses/Microsoft Training less

SQL Join Types

iTech Analytic Solutions

"iTech Analytic Solutions (iTAS)" is a leading MIS Reporting, Business Analytics, Data Analytics & Data...

There are four basic types of SQL joins: inner, left, right, and full. The easiest and most intuitive way to explain the difference between these four types is by using a Venn diagram, which shows all possible logical relations between data sets. 1. Inner Join2. Left Join3. Right Join4. Full Join read more

There are four basic types of SQL joins: inner, left, right, and full. The easiest and most intuitive way to explain the difference between these four types is by using a Venn diagram, which shows all possible logical relations between data sets. 

1. Inner Join
2. Left Join
3. Right Join
4. Full Join

read less
Comments
Dislike Bookmark

About UrbanPro

UrbanPro.com helps you to connect with the best Data Modeling Training in India. Post Your Requirement today and get connected.

Overview

Lessons 36

Total Shares  

+ Follow 1,919 Followers

Top Contributors

Connect with Expert Tutors & Institutes for Data Modeling

x

Ask a Question

Please enter your Question

Please select a Tag

X

Looking for Data Modeling Classes?

Find best tutors for Data Modeling Classes by posting a requirement.

  • Post a learning requirement
  • Get customized responses
  • Compare and select the best

Looking for Data Modeling Classes?

Find best Data Modeling Classes in your locality on UrbanPro

Post your learning requirement

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more