FAQ

To help you better understand Azure Data Factory and Amazon Glue, the following commonly asked questions (FAQs) have been categorized:

You can design data-driven processes for coordinating and automating data transportation and transformation with Azure Data Factory, a cloud-based data integration service.

  • Pipelines: Specify procedures for transferring and transforming data.
  • Activities: Pipeline-based tasks.
    Within data repositories, datasets serve as representations of data structures.
  • Linked Services: Establish connections with data repositories and processing power.
  • Triggers: Set up pipelines in response to particular occurrences.

Although Azure Data Factory can be integrated with Azure Stream Analytics or other services for real-time data processing, its primary purpose is batch data processing.

Yes, version control for pipelines and associated resources is made possible via integration with Git repositories like GitHub and Azure DevOps.

  • Data Flow Mapping: Transformations that are visually designed.
  • Custom Activities: Using Python,.NET, or other programming languages, create unique transforms.

The quantity of pipeline operations, data transfer volumes, and integration runtime consumption all affect pricing.

Yes, Azure Data Factory provides free use up to a set amount, which includes executing 1 million rows of data flow each month and five low-frequency operations.

More than 90 native connections are supported by Azure Data Factory, including those for SQL Server, Oracle, MongoDB, Azure Blob Storage, and Amazon S3.

Yes, Azure Data Factory can connect to on-premises databases and files using a self-hosted integration runtime.

For the purpose of preparing and loading data for analytics, AWS Glue is a fully managed ETL (Extract, Transform, Load) service.

  • Data Catalog: A centralized database for metadata.
  • Crawlers: Find and record information.
  • ETL Jobs: Data transformation and loading.
  • Triggers: Automate the completion of tasks.

 Because AWS Glue is serverless, completely managed, and intricately linked with the AWS ecosystem, it lowers operating costs.

Using AWS Glue Streaming ETL, AWS Glue can really process streaming data.

Yes, AWS Glue supports Python and Scala scripts and offers an ETL environment based on Spark.

The cost of AWS Glue is determined by:

  • run time of an ETL job.
  • Data Catalog requests and storage.
  • crawlers.

Yes, 10 data store API calls and one million Glue Data Catalog requests are available each month on the free tier.

MICROSOFT POWER BI FAQ

Power BI is a cloud-based data sharing environment. Once you have developed reports using Power Query, Power Pivot and Power View, you can share your insights with your colleagues. This is where Power BI enters the equation. Power BI, which technically is an aspect of SharePoint online, lets you load Excel workbooks into the cloud and share them with a chosen group of co-workers. Not only that, but your colleagues can interact with your reports to apply filters and slicers to highlight data. They are completed by Power BI, a simple way of sharing your analysis and insights from the Microsoft cloud.

Power BI Desktop is a free desktop application that can be installed right on your own computer. Power BI Desktop works cohesively with the Power BI service by providing advanced data exploration, shaping, modeling, and creating report with highly interactive visualizations. You can save your work to a file or publish your data and reports right to your Power BI site to share with others.

Microsoft has two parts for Self-Service BI. It is the online solution that enables you to share the interactive reports and queries that you have created using the Excel BI Toolkit.

 Self-Service Business Intelligence (SSBI)

  • SSBI is an approach to data analytics that enables business users to filter, segment, and, analyze their data, without the in-depth technical knowledge in statistical analysis, business intelligence (BI).
  • SSBI has made it easier for end users to access their data and create various visuals to get better business insights.
  • Anybody who has a basic understanding of the data can create reports to build intuitive and shareable dashboards.

Yes. Power BI desktop is free, but you will have access to the basic features of Power BI. Power BI comes in 3 levels. Power BI Desktop – Free for individual users. Power BI Pro – With Pro, you can share the data, reports, and dashboards with a large number of other users that also have a Power BI Pro license. You can also create an app based workspace. 

Power BI Premium – Premium License provides a dedicated unit of capacity for all users in the organisation. This dedicated capacity also called ‘Premium Workspace’ can be used to host large datasets up to 50GB. 

Power BI is the collective name for an assortment of cloud-based apps and services that help organizations collate, manage, and analyze data from a variety of sources, through a user-friendly interface.

Power BI is built on the foundation of Microsoft Excel, and as such, the learning curve from Excel to Power BI is not that steep; anyone who can use Excel can use Power BI, but the latter is far more powerful than its spreadsheet counterpart.

Having spent few years in both these technologies, it really depends on the need and purpose. Both are not complete BI stack and they serve a specific purpose. I.e. Self-service delivery of data but are not good in providing legacy grid based reporting. Here is quick guide on which one of these will i chose based on the scenario

  • If your data is in SAP, i would chose Lumira. If its Microsoft, I will pick Power BI
  • If you already have investment in SAP BI stack like Web-Intelligence then pick Lumira. If you have Microsoft BI stack like SSRS, then i would go with Power BI
  • SAP Lumira is on-premise solution. Power BI caters for both.

With Power BI Desktop, you can access SAP Business Warehouse (BW) data. … You can choose one or the other connector when connecting to SAP BW from Power BI Desktop. We suggest you use the Implementation 2.0 SAP Connector whenever possible.

Speed of development.

You can (right now) sign up, download the desktop software for free (limitations primary focused on the size of the data set – models larger than a GB will require a premium subscription – other than that – there’s really no distinction between the paid and free service), publish to your workspace and produce reports / dashboards by the end of day. Very little training is required for anyone familiar with standard BI / database experience (need to know what a join is / differences in data types, etc.) and there’s a lot of free self-guided training available. Also – Power BI meshes well with the entire Microsoft Office suite (Dynamics / GitHub, etc.) making it trivial to incorporate results to Excel, PowerPoint, etc.

To connect to an SAP HANA database from Power Query Desktop:

  1. Select Get Data > SAP HANA database in Power BI Desktop or From Database > From SAP HANA Database in the Data ribbon in Excel.

  2. Enter the name and port of the SAP HANA server you want to connect to. The example in the following figure uses SAPHANATestServer on port 30015.

  • The Microsoft PowerBI application can host in the cloud.
  • This hosted approach can help you and all the authorized users can access the reports on any type of device and where the users are.
  • You can monitor your live data and receive notifications on your mobile devices like smartphones and tablets.
  • The data continuously changes and always you would be updated and informed frequently.
  • Power BI is an innovative reporting tool and having the facility to create smart communicating dashboards.

  • This will give you the 360-degree business real-time data visual experience.

  • There are a lot of new user-friendly functionalities are easily allow you to interact with any external data.

  • Power BI provide you a new experience of the company’s data.

  • You can see all of your business data in one screen.
  • Power BI Mobile apps having features to automatically update your business data changes to your Power BI Dashboard.
  • so you can access your updated data and reports wherever you are.
  • Fast and robust access to your data

  • Data exploration and quick search

  • About all types of devices data insight

  • Can access to work across the company

  • Real-time dashboard monitoring

  • A consolidated clear dashboard

  • perfect support for business decision making

  • Accurate monitoring of performance

  • Easy Integration with ERP, CRM products, such as Excel

E-Commerce (wooCommerce ) FAQ

I would suggest a wonderful theme which M Shop. This is a free eCommerce WordPress theme comes with many advanced features and responsive design. You can find this theme on ThemeHunk platform. ThemeHunk design highly optimized themes and Plugins.

  1. Install WordPress
  2. Now you have a space to start building your website. To lay a foundation, use the free WordPress software platform.
  3. Many hosting companies have one-click WordPress installation available, so be sure to look for this option or ask if it’s available. Otherwise, you can download from WordPress.org and then install by following instructions at Famous 5-Minute Install.
  4. Pick a Theme
  5. Decide on the look of your website/store by selecting a theme. Use a free theme included with WordPress or purchase a premium theme.
  6. We recommend Storefront and its child themes because they are built and optimized for WooCommerce. Storefront is free. If you wish to add functionality, you can purchase Storefront extensions.
  7. If Storefront isn’t for you, there are lots of other themes that work great with WooCommerce.
  8. Activate WooCommerce
  9. With your website up and running, it’s time to install e-commerce functionality with WooCommerce. There are three ways to do this.
  10. Create a free account on WooCommerce.comSign-up for an account on WordPress.com: Create a Free Website or Blog and WooCommerce.comSelect from: A pre-installed solution with a trusted hostAuto-installing WooCommerce if you have a WordPress site already download the zip file and do it yourself
  11. Download the WooCommerce plugin download the plugin to your website to: Dashboard > Plugins > Add New > UploadSelect the downloaded pluginInstallActivate
  12. Search for the WooCommerce plugin from within your website to your website to Dashboard > Plugins > Add New > Search PluginsSearch for “WooCommerce” InstallActivate
  13. Upon activating the plugin, you are prompted with a Setup Wizard. We strongly advise following these steps, as it takes you through the initial setup.
  14. Extend WooCommerce
  15. Grow your store by adding functionality with extensions. We sell extensions for nearly everything: Subscriptions, Bookings, Memberships, payment gateways, shipping and much more.
  16. You can start a store/website for free and scale up as your customer base and revenue grow. Each extension is purchased on a subscription that gives you access to support and product updates. A subscription is billed annually.

WooCommerce is a free WordPress plugin that adds e-commerce functionality to your WordPress website so you can have an online store. With just a few clicks, your WordPress website turns into a fully-functional e-commerce website.

WooCommerce provides basic store functionality right out of the box, with a free plugin available from the Plugin Repository, or right from your WordPress dashboard.

While it has hundreds of available extensions – more on that in a bit! – it offers some incredible functions right out of the box.

WooCommerce is designed to make getting started as easy as possible, with a simple installation and Setup Wizard to get your e-commerce store up and running with your WordPress theme.

WordPress

WordPress is what we call a CMS, or Content Management System, software for designing websites, managing their content, publishing and updating them. It is an open source licensed content management system, making it accessible to everyone.

Indeed, it can be used by everyone, including those who do not have in-depth knowledge of web development. Know that you can download this CMS for free, read its code, share it and modify it.

And,

WooCommerce

WooCommerce is an open source WordPress plugin that allows you to have a 100% customizable online store , with multiple benefits and the opportunity to work with the WordPress dashboard.

The advantage of using WooCommerce is to be able to build your online store, while benefiting from the many advantages that WordPress offers. An excellent way not to shake up your habits when you are used to this CMS.

WooCommerce also occupies an important place in the e-commerce macrocosm. Indeed, according to the Built With site , more than 3 million online store sites are “powered” by this plug-in, and this, on an international scale!

Have a good day.

SEO FAQ

Search Engine Optimisation (SEO) is the process of improving the quality and quantity of website traffic to a website or a web page from search engines.

SEO can help you build better relationships with your audience, improve the customer experience, increase your authority, drive more people to your site, give you an edge over the competition, and increase conversions, which means more sales, more loyal customers, and more growth for your business.

Choosing an SEO plugin for your website might be difficult when you have so many options but don’t worry I am here to help you.

I will provide you with the best and most useful plugins for your website.
Let’s start:
First, decide the purpose why you want a plugin then choose it.

First, we will be looking at the SEO plugins for
First one is Yoast SEO it is an amazing plugin, I have been using it for a long time and it help’s a lot.

Second is RankMath: another and useful plugin, it has so many options and I have started using this plugin on some of my websites, this plugin has this schema feature for each article means you can decide the type of schema for each post pages.

For SEO these two plugins are sufficient don’t use both of them, pick anyone. I prefer using Yoast because I have been using it for a long time and I like it much.

Images
For Optimizing images, these are the plugins you can use
Smush: it has a free version without daily or monthly limits which is good for people who are just starting out.

ShortPixel Image Optimizer: It is also another useful WordPress image compression plugin. It requires you to get an API key by providing your email address. It has a limit of 100 images per month.

Here is a comparison test performed by wp beginner
As you can smush it getting the least score but I don’t think I would suggest you try out yourself and find which is perfect for you.

For CDN and Caching
W3 Total cache and wp rocked these two plugins also help in improving the site speed. Both the plugins have advance features such as image file compression, CDN, lazy loads, caching, etc that can make your site load fast.
Wp rocket is a paid plugin while W3 Total Cache is a free plugin, if you can afford wp rocket then it’s a good plugin you should definitely invest in it.

Page Builders
Divi: it is one of the best page builder plugins to use, with Divi you can create stunning and great designs.

Elementor: it is also an amazing plugin I prefer elementor because it is easy to use, it offers built-in templates moreover you can add some more features to this after installing some more plugins.
such as Happy Addon, Essential Addons.

I have used only these and these are sufficient ones that’s why I liked them you can visit my website Arpitspace dot in and have a look at the design. I have used elementor on this website

Schema Markup
For rich snippets, you can use All In One Schema Rich Snippets this is an amazing plugin for adding rich snippets and rich snippets helps in ranking your website average CTR of rich snippets is around 11%. You can configure each post while editing to insert more information for search engines. As you start editing, you will see an editor screen where you can select if the post is a product review or something else from a drop-down menu.

Bonus Tip
Themes:

Divi: one of the best themes is Divi you can customize and create your own design of webpages, it also has built-in templates which make your work easy and efficient.

Generatepress: it is an amazing theme although the home page is not so great we can customize it gives is not so good I like it because it is one of the fastest themes moreover it has built-in lightspeed so we don’t need to additionally install AMP plugin and google is preferring lightspeed websites.

Astra and Wp Ocean these are also good themes.
These are the top themes you should use.

These are some of the best plugins you can use on WordPress.
I hope you like it.

On-page SEO also called as “on-site” SEO is the act of optimizing different parts of your website that affect your search engine rankings. It’s stuff that you have control over and can change on your own website. Here are the biggest factors included.

TITLE TAGS

Put your targeted keywords in the title tag of each page on your site. There are many best practices that go into writing an effective title tag.

HEADINGS (H1)

Headings are usually the largest words on the page, and for that reason, search engines give them a little more weight than your other page copy. It is a good idea to work your target keywords into the headings of each web page, but make sure you accurately reflect your page content.

URL STRUCTURE

Put keywords into your URLs if possible. However, do not go changing all of your current URLs just so they have keywords in them. You shouldn’t change old URLs unless you plan on redirecting your old ones to your new ones. Consult a professional before doing this.

ALT TEXT FOR IMAGES

Any content management system should allow you to add something called “alt text” to all images on your website. This text isn’t visible to the average visitor – alt text is in fact used by screen reader software to help blind internet users understand the content of your images. Search engines crawl images in a similar way, so inserting some relevant keywords while accurately describing the image will help search engines understand your page’s content.

FAST-LOADING PAGES, OR PAGE LOAD SPEED

Google wants to help its users find what they’re looking for as quickly as possible to provide the best user experience. Therefore, optimizing your pages to load faster helps your site rank higher in the search results.

PAGE CONTENT

The content on your pages needs to be useful to people. If they search for something too specific to find your page, they need to be able to find what they’re looking for. It needs to be easy to read and provide value to the end user. Google has various ways to measure if your content is useful.

INTERNAL LINKING

Linking internally to other pages on your website is useful to visitors and it is also useful to search engines. Here’s an internal link to another blog post on our site that talks more about internal linking. Very meta.

On-page SEO ensures that your site can be read by both potential customers and search engine robots. With good on-page SEO, search engines can easily index your web pages, understand what your site is about, and easily navigate the structure and content of your website, thus ranking your site accordingly.

1. Community building in Social Networking Sites

This is the first step which is Also known as online reputation management, to popularize your website/business online. Try best social networking site’s communities and connect with your audience at a single place. This is the best off page activity and also gives your direct social web traffic. Use Facebook , Reddit , google+ , LinkedIn ,twitter and other social networking sites to achieve this task and grow your online audience easily .

2. Blogging

To grow a company online blogs are the best way of interaction with their audience. You should start a blog online and publish your company’s offers , new features , achievements etc . Through blog its easier to maintain all things at a single place. You can get dofollow links from your own blog . If you are not good at writing then you can hire a professional blogger and ask him to write precise and quality contents at cheaper prices. Quality contents will give you more search engine rankings and traffic.

3. Classified Submission

Ad posting sites are great way of link building and also the best seo practice in today’s time. Classified ad submission sites shows your website’s ad on their listings and when people search for related ads you will get traffic , sales , conversions and quality backlinks.

4. Forum Postings

Forums are great way of building relations directly . Join some popular forums of your website’s niche and start conversation . When people see your conversation they probably click on your links present on your comments . Few years ago These links are more powerful than others but today some seo experts tells that this is a black hat technique of link building. So its better to acquire few links from high quality sites/pages.

5. Search Engine Submission

When you first launch your website , its necessary to submit your site to search engines . The more your submit your site on search engines , the more presence you get on search engines. Ultimately this step is useful to let search engine know about your sites. Just add your site to google , bing and yahoo to get 80% of online market traffic. MSN.

6. Blog Submission

Blog submission is another important seo activity in our top seo checklist . When you submit your blog to blog submission sites. You start getting trust and traffic from search engines are backlinks from blog submission sites are of high quality and trustworthy.

7. PDF or document Submission

Now a days , PDF and document sharing activity becomes very popular. This involves sharing your documents on big document sharing sites and in return you will get backlinks to your sites. This activity is only useful if you want better search traffic from search engines.

8. Directory Submission

Directory submission was best known seo activity a few years back but now most of people agree that this is another black hat technique which you should never use. I personally recommend you to use only 5 best directory submission sites of high PageRank , traffic, and trust .

9. Profile Link Creation

Link building techniques includes profile link creation is another best seo checklist of 2015. In this type , we register on bigger websites for an account and then we add our website’s link in about me section. This is the easiest way of getting backlinks for free.

10. Local Listings & Yellow Pages

Instead of targeting global market first try to target local market to gain enough traffic for your business. As the global market is hard to target due to huge competition you can target local traffic to increase your business. Use sites like google local , yahoo local , maps , google business , google places , yellow pages , super pages , hot frog etc . Search engine loves local sites and gives preference to this type of sites.

11. Article Submission

instead of writing articles to your sites, you can write articles for other popular article submission sites like go articles , ezine etc and earn huge deep backlinks from these sites.

12. Social Bookmarking

Social bookmarking sites for seo is a great off page activity . These sites are used by peoples to save bookmark of their favorite sites online . You can also bookmark your site with sites like dig , delicious , StumbleUpon etc . These sites gives you high pr backlinks but nowadays these sites are hugely spammed by bloggers , so be carefull and create your links wisely .

13. Pinging

When you do changes in your site , then you should inform the search engine about your changes . But how to do that . ? This can be done by using pinging services. These sites inform search engines to crawl your site and update your search listings .

14. Link Exchange

Link exchange is a type of activity in which two bloggers or website owners exchanges links through their website , hence increase both people’s backlinks count . This is also known as reciprocal links. This technique comes under black hat seo techniques but you can do this in limits .

15. Cross-Linking / internal linking

cross linking tells how deeply your website’s content is related to each other. You should link your internal contents wherever is possible. This shows that you have very strong bonding between contents. This also shows that you have high quality contents. So build a better internal linking strategy.

16. Photo Sharing

To acquire links , you should do every possible activity . Photo sharing activity is one of the important off page activities presented here . In this strategy , you have to share your pictures/images in photo sharing sites with a link to your site. This gives you traffic and target backlinks . Share your photos

in major photo sharing websites like Instagram , Pinterest , Flickr, Picasa, Photo Bucket, Picli, etc.

17. Business Reviews

write a review about your business on your own or get it from your friends and family . Ask them to submit your review to major sites like. RateitAll, Shvoong, Kaboodle, Stylefeeder, etc.

18. Video Promotions

sites like YouTube gives option to write about videos , in about video section you can write your website’s link and get quality backlinks. Craft a high quality video and publish on sites like Metacafe, Dailymotion, etc .

19. Guest Post Submission

Guest post submission is a strategy in which bloggers write content to be published by other bloggers and in return they get backlinks from their contents and sites. To find guest blogging sites search ” write for us ” or post your articles etc .

20. Answers

Question and answers sites are like forums in which you ask something important and get answers from other peoples. You can answer questions of others and can include your website link in reference section .

21. Comment Posting

Comment posting is used by bloggers to gain backlinks in easy way . One have to comment on other sites with included backlinks and after successful publishing comment on other site user gets a backlinks . However this way you can easily get banned from commenting but doing in limits can give you big seo benefits.

22. Profile Linking

Some websites have about me section for their users . Nowadays blogger uses this feature to get backlinks from these sites. You can create an account on sites like apsense , YouTube etc. For more sites you can also click on below articles.

23. PPC Ad Campaign

This is last activity , if you are not satisfied with about activities , then you can promote your site by using PPC (pay per click ) programs. In this program, you will get paid traffic by registering on sites like adsense , clicksor .

Search Engine Optimisation is the backbone of any website to get visibility and trust for customers as well as for search engines.SEO practice can reduce the manipulation of results as much as possible. So that the websites are visible for the search query because they deserve to be there.

If you have a website, you will naturally want it to rank high in Google and other search engines. This visibility and exposure along with many other factors drive organic traffic to your site.

If you are working with a budget then organic SEO can save your money. But you can also use paid website traffic to get more conversions, If you are thinking for long term Organic SEO is the best option.

Organic SEO is crucial for any business and its primary resource of website traffic. We know that a clear majority of the world that has access to the internet is visiting Google at least once a day to get information. Highly visible in search engine giant Google and other search engines can give brand credibility and higher traffic source.
Everyone looking for better organic results and maximum traffic gives a better user experience to make conversions. Customers know what they want. If they can’t find it, there’s going to be a problem. And performance will suffer. Quality SEO incorporates a positive user experience, leveraging it to work in a brand’s favor.
For small and medium businesses local marketing has placed a crucial role in their marketing strategy. Local SEO aims at optimizing your digital properties for a specific vicinity, so people can find you quickly and easily, putting them one step closer to a transaction.
Most of the customers do at least basic research on the product or service which they are going to buy. that’s one of the biggest advantages of the internet from a consumer’s perspective. Using SEO strategies to convey your message for good deals, products, and/or services, and the importance and dependability of what you offer customers will be a game-changer. ultimately this leads customers to purchase from your website if everything was done in the right way.
High-quality SEO will always find a means of discovering and leveraging new opportunities for brands to, not just be discovered, but to shine. The better a brand is understood, the more opportunities will arise to help it thrive.

Implement strong SEO is always going to be beneficial. Because of having lots of competency in business, we must implement high-quality SEO to compete and gain high traffic, Visibility for consumers.